Trying to write data to specific column using pandas dataframes

Question

`

import pandas as pd
import numpy as np
import csv

header = ["Blues", "Jazz", "Rock", "Country", "Pop", "Rap", "Metal", "Classical"]

with open("music.csv", "w") as SectorCSV:
    csvwriter = csv.writer(SectorCSV, lineterminator = "\n")
    print("Creating Sector.csv")
    csvwriter.writerow(header)

df = ["Beethoven", "Mozart", "Adele", "Beyonce", "Nirvana", "Eminem", "Metallica", "Bach"]
df = pd.DataFrame(df)
df.to_csv("Sector.csv", index=False, columns=header, mode="a")

`

For example I want to append Beethoven into the classical column but I can't figure out how to append data to a specific column.

1 example of an error: KeyError: "None of [Index(['Blues', 'Jazz', 'Rock', 'Country', 'Pop', 'Rap', 'Metal', 'Classical'], dtype='object')] are in the [columns]"

Lokeshwar G · Accepted Answer · 2022-11-01 08:36:00Z

1

I'm this is what you are excepting

df = pd.DataFrame()
df['columnname'] = ["Beethoven", "Mozart", "Adele", "Beyonce", "Nirvana", "Eminem", "Metallica", "Bach"]
df.to_csv("Sector.csv", index=False, columns=header, mode="a")

answered Nov 1, 2022 at 8:36

Lokeshwar G

1466 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

xlmaster Over a year ago

shouldn't be? df['Classical']=...

Lokeshwar G Over a year ago

yes you can change the column name based on header

pythonic Over a year ago

It still gives me this error: KeyError: "None of [Index(['Blues', 'Jazz', 'Rock', 'Country', 'Pop', 'Rap', 'Metal', 'Classical'], dtype='object')] are in the [columns]"

pythonic Over a year ago

All I want is to append data to a column under a specific header

Lokeshwar G Over a year ago

or you can try this { df=pd.read_csv("music.csv") df1 = pd.DataFrame() df1['median_house_value'] = ["Beethoven", "Mozart", "Adele", "Beyonce", "Nirvana", "Eminem", "Metallica", "Bach"] df3=pd.concat([df,df1],ignore_index=True) }

Collectives™ on Stack Overflow

Trying to write data to specific column using pandas dataframes

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related