Breaking News: Grepper is joining You.com. Read the official announcement!

add new column to an csv file and fill it then save the file

Hussain Abbas answered on August 15, 2022 Popularity 3/10 Helpfulness 1/10

answer add new column to an csv file and fill it then save the file

related add a column to a CSV file in Python

add new column to an csv file and fill it then save the file

Comment

import csv

# Define the function abc() - replace this with your own function implementation
def abc(value):
    return value * 2  # For example, doubling the input value

def add_new_column(input_file, output_file):
    # Read the CSV file and store its data in a list of dictionaries
    with open(input_file, 'r') as csvfile:
        reader = csv.DictReader(csvfile)
        data = list(reader)

    # Add a new column to the data and fill it with the result of abc() function
    for row in data:
        new_column_value = abc(int(row['SomeColumn']))  # Replace 'SomeColumn' with the name of the column you want to use as input
        row['NewColumn'] = new_column_value

    # Write the modified data back to the CSV file with the new column
    fieldnames = reader.fieldnames + ['NewColumn']
    with open(output_file, 'w', newline='') as csvfile:
        writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
        writer.writeheader()
        writer.writerows(data)

if __name__ == "__main__":
    input_csv_file = "input.csv"  # Replace with the name of your input CSV file
    output_csv_file = "output.csv"  # Replace with the desired name of your output CSV file
    add_new_column(input_csv_file, output_csv_file)
    print("New column added and CSV file saved successfully!")

Popularity 3/10 Helpfulness 1/10 Language python

Source: chat.openai.com

Tags: add csv file fill python save

Link to this answer
Share Copy Link

Contributed on Jul 20 2023

Hussain Abbas

0 Answers Avg Quality 2/10

Closely Related Answers

add a column to a CSV file in Python

Comment

df = pd.read_csv("sample.csv")
df["new_column"] = "abc"
df.to_csv("sample.csv", index=False)

Popularity 9/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: add csv

Link to this answer
Share Copy Link

Contributed on Aug 15 2022

umar zia

0 Answers Avg Quality 2/10

add new column to an csv file and fill it then save the file

Contents

More Related Answers

add new column to an csv file and fill it then save the file

Closely Related Answers

add a column to a CSV file in Python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.