| 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) | |