Mar-28-2020, 04:01 PM
Hi,
I have two csv files,
csv1:
desired output:
but they are not merging properly.
I have two csv files,
csv1:
c1 c2 c3 c4 c5 BB 2 5 6 Ocsv2:
c7 c8 c9 c10 c11 C 0 2 0 LI want to read both files(ignore headers), and merge data:
desired output:
BB 2 5 6 O C 0 2 0 LI use below code,
but they are not merging properly.
final_df=[]
for filename in fList:
df = pd.read_csv(filename, index_col=None, header=0)
print(df)
print("--"*12)
final_df.append(df)
df_concat = pd.concat(final_df, axis=0, ignore_index=True)
