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)