0

I want to create 6 pandas dataframes from 6 text files. I want to name them according to the names of the text files. The text files are named as 'DAPC_min.txt' and so on. I want the dataframe names as 'DAPC_data' and so on.

import pandas as pd

lipids = ['DAPC', 'DIPC', 'DLPC', 'DOPC', 'DPPC', 'POPC']

for lipid in lipids:
    '{}_data'.format(lipid) = pd.read_csv(
        '{}_min.txt'.format(lipid),
        delimiter=' ', names=['bead_type', 'z_min', 'gz_min', 'dGwm'])

But I am getting the following error message:

'{}_data'.format(lipid) = pd.read_csv(
    ^
SyntaxError: can't assign to function call

What I am doing wrong?

Improve this question
7
  • You can try using a dictionary. Key is the file name and the DF is the value Commented Jun 14, 2018 at 10:52
  • You try to assign the values from the files to a string. What i would suggest is that you use a dict where the file names are the keys and the values well ... the values. Commented Jun 14, 2018 at 10:52
  • Possible duplicate of stackoverflow.com/questions/13096604/… and others Commented Jun 14, 2018 at 10:56
  • I've added a duplicate which does this for excel worksheets. You can use the same for csv files. Commented Jun 14, 2018 at 10:56
  • 1
    @anotherone Define a dictionary to hold those variables outside the loop, say dct = {} and then inside the loop, change the left hand side to: dct['{}_data'.format(lipid)] = pd.read_csv(...) The way you are currently doing is possible in some languages (with some hacks in Python too) but using a dictionary in these situations is strongly recommended. Commented Jun 14, 2018 at 11:12
Related questions
13111
What does the "yield" keyword do in Python?
8109
Does Python have a ternary conditional operator?
5660
How can I access the index value in a 'for' loop?
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.