how to read a dictionary line from txt file?

[Doug]

Hey! I have a txt file with multiple dictionary lines. How could I possible read it literally as a dictionary line or straight as a dictionary line value in to the python file?
my txt file:
{'Cost': 22, 'Income': 1, 'Month': 'a', 'Cash1': 23, 'Cash2': 2, 'Investments': 3}
{'Cost': 22, 'Income': 1, 'Month': 'b', 'Cash1': 23, 'Cash2': 2, 'Investments': 3}
{'Cost': 22, 'Income': 1, 'Month': 'c', 'Cash1': 23, 'Cash2': 2, 'Investments': 3}

I was trying this way, but yet it still reads data as a string..

    def Chart_data(self):        
        with open('abc.txt') as f:
            data = []            
            for line in (line for line in f if line.rstrip('\n')):
                data.append(int(eval(line['Cash1'])))

Many thanks for your help!

[nilamo]

Are you creating the file? Because it'd be much easier if it wasn't in this format. If you could somehow get json/yaml, or even a pickle file, that'd be simple to do.

If that's not possible, I'd suggest using a regular expression to parse the line.

---

For example, here's a rough looking regex which works for your sample data:

>>> lines = '''{'Cost': 22, 'Income': 1, 'Month': 'a', 'Cash1': 23, 'Cash2': 2, 'Investments': 3}
... {'Cost': 22, 'Income': 1, 'Month': 'b', 'Cash1': 23, 'Cash2': 2, 'Investments': 3}
... {'Cost': 22, 'Income': 1, 'Month': 'c', 'Cash1': 23, 'Cash2': 2, 'Investments': 3}'''.split('\n')
>>> import re
>>> regex = re.compile(r"('([^']+)':\s+'?([^,'}]+)'?,?\s*)")
>>> dicts = []
>>> for line in lines:
...   groups = regex.findall(line)
...   object = {}
...   for group in groups:
...     object[group[1]] = group[2]
...   dicts.append(object)
...
>>> for obj in dicts:
...  print(obj)
...
{'Cost': '22', 'Income': '1', 'Month': 'a', 'Cash1': '23', 'Cash2': '2', 'Investments': '3'}
{'Cost': '22', 'Income': '1', 'Month': 'b', 'Cash1': '23', 'Cash2': '2', 'Investments': '3'}
{'Cost': '22', 'Income': '1', 'Month': 'c', 'Cash1': '23', 'Cash2': '2', 'Investments': '3'}

[ichabod801]

If you're going to use eval, just eval the whole line. But don't use eval if you don't trust where the data is coming from.