Skip to content
TheChatArchiveThe Chat Archive
gpt-4-1106-preview· OpenAIAi2 WildChat-4.8M (AI2)

i have several csv files with exact same columns that i want to combine to one file give…

  1. User

    i have several csv files with exact same columns that i want to combine to one file give me proper python code

  2. Assistant

    Certainly! You can use the pandas library in Python to easily combine multiple CSV files with the same columns into one. If you haven't already installed pandas, you can install it using pip:

    pip install pandas
    

    Here's a Python script that demonstrates how to combine several CSV files into one:

    import pandas as pd
    import os
    
    # Directory where all your CSV files are located
    csv_directory = 'path/to/your/csv/files'
    
    # List all CSV files in the given directory
    csv_files = [file for file in os.listdir(csv_directory) if file.endswith('.csv')]
    
    # Placeholder for storing the data frames
    data_frames = []
    
    # Loop over the list of csv files
    for csv_file in csv_files:
        # Read the CSV file and append it to the list of data frames
        file_path = os.path.join(csv_directory, csv_file)
        df = pd.read_csv(file_path)
        data_frames.append(df)
    
    # Concatenate all data frames to create a single data frame
    combined_df = pd.concat(data_frames, ignore_index=True)
    
    # Save the combined data frame to a new CSV file
    combined_csv_path = 'path/to/your/destination/combined_file.csv'
    combined_df.to_csv(combined_csv_path, index=False)
    
    print(f'Combined CSV created at: {combined_csv_path}')
    

    Make sure to replace 'path/to/your/csv/files' with the actual path to the folder containing your CSV files, and replace 'path/to/your/destination/combined_file.csv' with the desired path and file name for the combined CSV file.

    This script reads all the CSV files in the specified directory, concatenates them into a single DataFrame, and then outputs that combined DataFrame to a new CSV file. Ensure that the files do not contain any additional headers in between data, as this script assumes the CSV files have headers only once at the beginning.