chess-mamba-vs-xformer / merge_csv.py
HaileyStorm's picture
Upload 5 files
80bc2b3 verified
raw
history blame
485 Bytes
import pandas as pd
# Read the first CSV file
df1 = pd.read_csv('/media/hailey/TVBox/lichess_db_stable.csv')
# Read the second CSV file and filter it
df2 = pd.read_csv('/media/hailey/TVBox/lichess_transcripts_2.csv')
#df2 = df2[df2['Result'] == '1-0'][['transcript']]
# Concatenate the filtered DataFrames
merged_df = pd.concat([df1, df2], ignore_index=True)
# Save the merged DataFrame to a new CSV file
merged_df.to_csv('/media/hailey/TVBox/lichess_db_stable2.csv', index=False)