create new csv file to local drive

Question

finalfaultdata = pd.read_csv('FinalFaultData.csv')

passedmaster = pd.read_csv('PASSEDMASTER.csv')

A = pd.concat([finalfaultdata,passedmaster])

print(A)

with open ('output.csv', 'w') as output:

writer = csv.writer(output)

writer.writerows(A)

Its just a simple syntax error. try this: pd.concat([finalfaultdata,passedmaster]) — Boskosnitch, May 07 '21 at 05:24

Alberto Neto Brocardo · Answer 1 · 2021-05-07T15:24:38.800

0

As you are using Pandas, you can merge the dataframe:

finalfaultdata = finalfaultdata.merge(passedmaster)

To save it as a CSV you can simply use:

finalfaultdata.to_csv('finalfaultdata.csv')

edited May 07 '21 at 15:24

answered May 07 '21 at 05:37

how to download this merge file as new csv file in text – Pavan Rajput May 07 '21 at 05:44
I updated the answer with to_csv method – Alberto Neto Brocardo May 07 '21 at 15:25

1 Answers1