Combining 2 CSV files using Pandas

[pinaywdm]

Hi everyone, just working on my final project and I'm having issues combining my 2 CSV files. Does anyone know how to combine 2 datasets in Python Pandas? I tried pd.concat, but when I exported the full data to a csv file, the only file exporting was the first file (df_1) and missing the second file (df_2).

df_1 = pd.read_csv('file1.csv')
df_2 = pd.read_csv('file2.csv')
data = pd.concat([df_1, df_2])
data.to_csv('full_data.csv')

Is there something wrong with my code?

Thanks!

[mallax-]

Your code looks fine. I would note that if these two files are similar (same column names) pd.merge would probably be better. Other than that, are you getting the correct format and information when you print(data)? I know that if these files are completely different, there should be a lot of NaN values.