Dear ,
I am a beginner in python programming. Can anyone help me? I have a problem in pandas related to arrange my dataframe. Really, I have many csv files, lets say now I have only 3 files in a single folder with three columns each file.
1.csv 2.csv 3.csv
A B C A B C A B C
5 23 56 5 43 23 5 65 08
10 31 77 10 76 66 10 34 72
20 33 98 20 39 28 20 23 64
30 18 26 30 27 39 30 73 92
I want to make a new csv file with A column and add only each B columns from another csv files by looping, like below:
desired result :
new.csv
A B B B
5 23 43 65
10 31 76 34
20 33 39 23
30 18 27 73
My Script :
import pandas as pd
import numpy as np
import csv
import glob
import os
path = “C:/Users/SYIFAAZRA/Documents/belajar_wradlib/learning/”
os.chdir(path)
file = glob.glob("*.csv")
aa = []
for f in file:
aa.append(pd.read_csv(f))
df = aa[0].iloc[:,:2]
for i, a in enumerate(aa[1:]):
df[str(i)] = a.iloc[:,1]
print (df)
The result :
5 23 0 1
0 10 31 76 34
1 20 33 39 23
2 30 18 27 73
My question is whats wrong with my script. Because in the first row at column 2 and column 3 is not the exact value. Thats 0, 1 it should be 43, 65. Please Help Me…