CODEWITHSUNDEEP
pandas
Victor
Victor

Reputation: 17087

Pandas giving error while adding a list to a Series

I am having error trying to add a list to a pandas series A. The series A has 2 elements:

1     0.0
46    0.0
Name: ACCT_BAL, dtype: float64

The list, which is created by calling tolist() on a Series (The Series is 1 column from a dataframe) has 1 element:

[0.0]

But when I do:

A=A.add(list)

I get:

ValueError: Lengths must be equal

Upvotes: 0

Views: 168

Answers (1)

Georgina Skibinski
Georgina Skibinski

Reputation: 13387

I suppose pd.Series.append(..., ignore_index=True) is what you're looking for:


df=pd.Series([0.0, 0.0], index=[1,46], name="ACCT_BAL")
df_2=pd.Series([1.0, 20, 2.3], name="irrelevant_col_name")
df_3=pd.Series([765], name="irrelevant_col_name")

df=df.append(df_2, ignore_index=True)

#outputs:
>>> df
0     0.0
1     0.0
2     1.0
3    20.0
4     2.3
dtype: float64

df=df.append(df_3, ignore_index=True)

#outputs:
>>> df
0      0.0
1      0.0
2      1.0
3     20.0
4      2.3
5    765.0
dtype: float64

Upvotes: 1

Related Questions