adding all list value to to dataframe

Question

I have a list consisting of several string as shown below list=['abc','cde','fgh'] I want to add all the values to a particular index of dataframe. I am trying it with the code

df1.ix[1,3]=[list]
df1.to_csv('test.csv', sep=',')

I want in dataframe at poistion 1,3 all values to be inserted as it is ['abc','cde','fgh']. I don't want to convert it to string or any other format. But it is giving me error. what I am doing wrong here

the error is ----raise ValueError('Must have equal len keys and value ' ValueError: Must have equal len keys and value when setting with an ndarray — nishant kumar
– nishant kumar, Commented Oct 21, 2016 at 12:07
Can you add sample of df1? Please check How to make good reproducible pandas examples — jezrael
– jezrael, Commented Oct 21, 2016 at 12:08

jezrael · Accepted Answer · 2016-10-21 12:09:50Z

3

I think you can use:

df1.ix[1,3] = L

Also is not recommended use variable list, because code word in python.

Sample:

df1 = pd.DataFrame({'a':[1,2,3], 'b':[1,2,3], 'c':[1,2,3], 'd':[1,2,3]})
print (df1)
   a  b  c  d
0  1  1  1  1
1  2  2  2  2
2  3  3  3  3

L = ['abc','cde','fgh'] 
df1.ix[1,3]= L

print (df1)
   a  b  c                d
0  1  1  1                1
1  2  2  2  [abc, cde, fgh]
2  3  3  3                3

answered Oct 21, 2016 at 12:09

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

4 Comments

nishant kumar Over a year ago

still have this error ---- raise ValueError('Must have equal len keys and value ' ValueError: Must have equal len keys and value when setting with an iterable

jezrael Over a year ago

It return error with my sample? Or sample works and problem is with real data?

jezrael Over a year ago

What is your pandas version print pd.show_info() ?

nishant kumar Over a year ago

version is 0.19.0

piRSquared · Accepted Answer · 2016-10-21 17:11:40Z

1

I think you meant to use 1:3 not 1,3

consider the pd.DataFrame df

df = pd.DataFrame(dict(A=list('xxxxxxx')))

use loc or ix
df.loc[1:3, 'A'] = ['abc', 'cde', 'fgh']
or
df.ix[1:3, 'A'] = ['abc', 'cde', 'fgh']
yields

edited Oct 21, 2016 at 17:11

answered Oct 21, 2016 at 15:52

piRSquared

296k68 gold badges509 silver badges654 bronze badges

Collectives™ on Stack Overflow

adding all list value to to dataframe

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related