I printed out the i value using the following equation.
path ="./"
file_list = os.listdir(path)
file_list_csv = [file for file in file_list if file.endswith(".csv")]
g = it.groupby(file_list_csv, lambda name:name[:5])
for k, v in v:
print(k)
for i in v:
print(i)
Output result is
The result of print(i) is
2TB-4UDT.csv
2TB-4NST.csv
That's how it's printed out.
Then I'll use the result i (continue the code)
file1= pd.read_csv(i)
result = pd.concat([file1], axis=1)
k0 = k+'.csv'
result.to_csv(k0, header=True, index=False)
You want to merge the two files "2TB-4UDT.csv" and "2TB-4NST.csv" into one Excel file ("2TB-4.csv").
Can I use the result value i?
If you run that code as it is, only the contents of the last file, "2TB-4NST.csv", are saved.
Thank you for reading this long article!
python for
for k, v in v:
files = [ pd.read_csv(filename) for filename in v ]
result = pd.concat( files, axis=1 )
result_file_name = k + ".csv"
result.to_csv(result_file_name, header=True, index=False)
© 2024 OneMinuteCode. All rights reserved.