How to use %d to auto automation read maltiple varible

Question

I have many sets of data that need to be read into the same DataFrame The variable names of each group of data are data_1 data_2 ... etc.

So I hope that the data can be read in with one line of instructions instead of input line by line However, there seems to be something wrong with the characterization method. I have checked Google and have not seen similar problems, so I came up to ask you all, thank you.

And.. below is my try.

for i in range(40):
    test_frame.append([data_'%d'%(i)])

You should be using a `list` data structure, rather than storing in separate variables like `data_1, data_2, ...` etc — Vishnudev Krishnadas, Mar 19 '21 at 07:44
Are your sets of data in files (what format?) How are they stored? — Serge de Gosson de Varennes, Mar 19 '21 at 07:49
Dynamic variable names is a terrible idea. Unsure of a true duplicate, but I think that the answer is [How do I create variable variables?](https://stackoverflow.com/q/1373164/3545273) — Serge Ballesta, Mar 19 '21 at 08:10

score 0 · Answer 1 · answered Mar 19 '21 at 07:51

Been there, done that :)

since I don't know what's the type of data_x, I assume it is not a dataframe as you are using a list.

for i in range(40):
    test_frame = test_frame.append([data_'%d'%(i)])

If its a dataframe

for i in range(40):
    test_frame = test_frame.append(data_'%d'%(i))

Appending in pandas is not an in-place operation

How to use %d to auto automation read maltiple varible

1 Answers1