File size: 485 Bytes
80bc2b3 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
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)
|