I'm doing an inform and with a group we run the experiment ten time and had created 10 csv files. But opening all one line of code at a time must not be the most efficient way to open and read them and I know there must be a way to open them with a for cicle.

For now I have this code,changing cn1 with cn2 and so on:

import numpy as np
import matplotlib.pyplot as plt
import pandas as pd

cn1 = pd.read_csv ("Cuerpo Negro 1 Volt.txt",skiprows=1)

datos1 =pd.DataFrame (cn1)

What is the way to, with less lines, to open them all?

I have all the archive in the same file I'm working

Thanks for your help

Ps:I have plt because I need to graphic them later, but there must not be a problem to repeat the same code for use to transform the csv to a data frame.

CodePudding user response：

If I understood you correctly what you want is a list with all your pandas DataFrames from your csv file. So frames is a list in which step by step all the DataFrames df are appended to. They are accessible by frames[index]

import numpy as np
import matplotlib.pyplot as plt
import pandas as pd

number_of_files = 10
frames = []
filename = "your_file{number}.csv" # In your case: "Cuerpo Negro {number} Volt.txt"

for i in range(1, number_of_files 1):
    df = pd.read_csv(filename.format(number=i), skiprows=1)
    frames.append(df)