I want to open multiple files using a list of names and such that the names of the opened files will also incorporate the names in the list, as shown below:
List = ["Sin", "Cos", "Tan"]
for x in List:
df_x = pd.read_csv("C:\\Users\\gtala\\OneDrive\\Desktop\\TIME AI\\NIST_Tests\\constants\\x.txt")
So I want x to replace x in the name of the file and in the directory, such that eventually I will open df_Sin from Sin.txt and df_Cos from Cos.txt, etc.
Thanks.
import pandas as pd
List = ["Sin", "Cos", "Tan"]
base="C:\\Users\\gtala\\OneDrive\\Desktop\\TIME AI\\NIST_Tests\\constants\\"
df = {}
for x in List:
df[x] = pd.read_csv(base + x +".txt")
In the dictionary, df, above, the Sin variables are accessed using df['Sin'], for example, as follows:
print df['Sin']
mapf = "C:\\Users\\gtala\\OneDrive\\Desktop\\TIME AI\\NIST_Tests\\constants\\{}.txt".format
list(map(pd.read_csv, map(f, ["Sin", "Cos", 'Tan'])))
You may find it useful to store this in a dictionary data structure instead.
path = "C:\\Users\\gtala\\OneDrive\\Desktop\\TIME AI\\NIST_Tests\\constants"
file_names = ["Sin", "Cos", "Tan"]
df_dict = {f"df_{x}": pd.read_csv(f"{path}//{x}.txt") for x in file_names}
You can then access a dataframe of interest by using
df_dict['df_Sin']
f"df_{x}" rather than format (same with filepath) and save the directory path as a variable outside the dict to make it cleanerpath = "C:\\Users\\gtala\\OneDrive\\Desktop\\TIME AI\\NIST_Tests\\constants" outside and then we have df_dict = {f"df_{x}: pd.read_csv(f"{path}//{x}.txt" for x in file_names}