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)