Merging the two different column datasets into one

Tony_fanto · March 30, 2019, 4:20pm

How to merge the (different column)3 Csv file into single csv file

Bhuvana_ka · March 30, 2019, 4:30pm

You can use df.to_csv.

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_csv.html

Tony_fanto · March 30, 2019, 4:40pm

Can you please explain in detail ?

Bhuvana_ka · March 31, 2019, 6:37am

Hi, can u please exactly mention what are you looking for.

Do you have three csv files and you are trying to load them into one csv file ?

Tony_fanto · March 31, 2019, 6:57am

Yeah…and in that three CSV file some columns are same and some columns are differing…so that I want to merge it properly , otherwise it will be in trouble .
That’s why am asking exactly what to do?

sergeman · March 31, 2019, 5:26pm

This sort of things are usually accomplished by using relational join. You might want to look into relational join tutorials. Quick search yielded this site http://www.sql-join.com/, but there are many others.

Bhuvana_ka · March 31, 2019, 6:57pm

Hi,

Alternatively you can load the csv files in three different dataframes. If you want specific columns use usecols to get those columns alone.
you can then concatenate the dataframe using pd.concat into one.
This dataframe could be easily converted to csv using pd.to_csv

Hope this helps.