Adding data to pandas dataframe with no header

Question

I am trying to add a row(list of int) to pandas dataframe but i am somehow unable to append it. The thing is the dataframe has no header and everywhere the put data through specifying column names. I dont understand how to do it without header. Below is my dataframe named sheet

sheet = pd.read_csv("labels.csv",header = None) #sheet = [[1,1,1,2,2 ...]]

i want to append resulting list named simple_list = [1,2,3,4,2,1,1,1] to it.

What's does the error say? How many columns are in your dataframe? Does this number agree with the number of datapoints in simple_list? For example, how does sheet.head() look? — nostradamus
– nostradamus, Commented Jan 9, 2020 at 15:59
It numbers them with indeces 0,1,2,3,....59999 and place points under them — Bilal Nadeem
– Bilal Nadeem, Commented Jan 9, 2020 at 16:10
from what i understood u wanted to add a row to your dataframe? — Umar.H
– Umar.H, Commented Jan 9, 2020 at 16:14
@Datanovice the first line says so ... trying to add a row(list of int) — Bilal Nadeem
– Bilal Nadeem, Commented Jan 9, 2020 at 16:16

Sam Chats · Accepted Answer · 2020-01-09 16:07:01Z

1

Does the following work?

sheet = sheet.append(pd.DataFrame([[1,2,3,4,2,1,1,1]]), ignore_index=True)

answered Jan 9, 2020 at 16:07

Sam Chats

2,3211 gold badge14 silver badges36 bronze badges

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

Comments

xopclabs · Accepted Answer · 2020-01-09 16:07:50Z

0

You need to create a series out of simple_list.

simple_series = pd.Series(simple_list)

Then you can append a row to your dataframe with argument ignore_index=True:

sheet = sheet.append(simple_series, ignore_index=True)

answered Jan 9, 2020 at 16:07

xopclabs

111 silver badge1 bronze badge

Comments

Rolando Galindo · Accepted Answer · 2020-01-09 16:16:38Z

0

This work for me. sheet.appends returns a dataframe, you need to assign it to the same var or a new one to us it. If not "sheet" will have always the original CSV content

import pandas as pd

if __name__ == '__main__':
    sheet = pd.read_csv("labels.csv", header=None)
    sheet = sheet.append([[41, 42, 42, 44, 45]], ignore_index=True)

answered Jan 9, 2020 at 16:16

Rolando Galindo

113 bronze badges

Collectives™ on Stack Overflow

Adding data to pandas dataframe with no header

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related