Apologies in advance if the problem sounds too trivial but I could not find any solution on the forum.
I want to merge two csv files.
file1:
name age city
john 20 abc
jack 15 def
alice 25 ghk
file2:
hobby grade
tyu 8
ghj 9
hjk 10
output file:
name age city hobby grade
john 20 abc tyu 8
jack 15 def ghj 9
alice 25 ghk hjk 10
What is the best way to do this? Can we do this using pandas?
Appreciate any help.
Thanks!
I'm assuming based on your example data that you're dealing with tab delimiters, not commas.
I believe what you're trying to do is generally referred to as concatenation, whereas merging is a database-style join on columns or indexes. Perhaps that's why you were having difficulty searching for a solution.
You can easily accomplish what you want with pandas as in the following:
import pandas as pd
a = pd.read_csv("file1.csv", delimiter="\t")
b = pd.read_csv("file2.csv", delimiter="\t")
print(pd.concat([a, b], axis=1).to_csv(index=False, sep="\t"))
Result:
name age city hobby grade john 20 abc tyu 8 jack 15 def ghj 9 alice 25 ghk hjk 10
delimiter="\t" and sep="\t" named arguments.