combine-all-csvs.py

import pandas as pd

# List of CSV file names
csv_files = [
    "output/2024-05-19-ema-8x21-pullback-stocks-report.csv",
    "output/2024-05-19-8x21-stocks-report.csv",
    "output/2024-05-19-ema21-bounce-stocks-report.csv",
    "output/2024-05-19-power-of-3-daily-stocks-report.csv",
    "output/2024-05-19-power-of-3-weekly-stocks-report.csv",
    "output/2024-05-19-5d-volume-stocks-report.csv",
    "output/2024-05-19-4d-volr-g-g-candles-stocks-report.csv",
    "output/2024-05-19-2w-volgg-candles-stocks-report.csv",
    "output/2024-05-19-123-pullbacksdaily-stocks-report.csv",
    "output/2024-05-19-123-pullbacksweek_1-stocks-report.csv",
    "output/2024-05-19-mean-rev-50-lowerbb-stocks-report.csv",
    "output/2024-05-19-mean-rev-lowerbb-stocks-report.csv",
    "output/2024-05-19-mean-reversion-21-lowerbb-stocks-report.csv",
    "output/2024-05-19-squeeze-up-stocks-report.csv",
    "output/2024-05-19-momentum-trending-stocks-report.csv",
]

# Initialize an empty list to store the dataframes
dfs = []

# Loop through the CSV file names
for file in csv_files:
    # Read the CSV file into a dataframe
    df = pd.read_csv(file)
    # Append the dataframe to the list
    dfs.append(df)

# Concatenate all dataframes in the list into a single dataframe
combined_df = pd.concat(dfs, ignore_index=True)

# Export the combined dataframe to a new CSV file
combined_df.to_csv("output/combined_output.csv", index=False)