df.append() is not appending to the DataFrame
Solution 1
DataFrame.append
is not an in-place operation. From the docs,
DataFrame.append(other, ignore_index=False, verify_integrity=False, sort=None)
Append rows of other to the end of this frame, returning a new object. Columns not in this frame are added as new columns.
You need to assign the result back.
df8 = df8.append([s] * 2, ignore_index=True)
df8
A B C D
0 value aa value bb value cc value dd
1 value aa value bb value cc value dd
Solution 2
The statement data.append(sub_data)
does not work on its own.
But the statement data=data.append(sub_data)
will work
Assigning it back solved the issue for me. Good tip not available elsewhere.
JFerro
NLP with Spacy Pandas Networkx ipywidgets, ipysheets, voila, ipyvuewtify in Jupyter Hub environement NLP for patent literature. Feature extraction. EPC & PCT compliance based on NLP techniques. Interested in Machine learning for information extraction in EN, FR, DE, NL, SP, PT languages.
Updated on January 09, 2022Comments
-
JFerro over 2 years
I formulated this question about adding rows WITH index, but it is not yet clear to me how/why this happens when there are no indexes:
columnsList=['A','B','C','D'] df8=pd.DataFrame(columns=columnsList) L=['value aa','value bb','value cc','value dd'] s = pd.Series(dict(zip(df8.columns, L))) df8.append(s,ignore_index=True) df8.append(s,ignore_index=True)
I EXPECT HERE A 2X4 DATAFRAME. nevertheless no values where added, nor an error occurred.
print(df8.shape) #>>> (0,4)
Why is the series not being added, and why is not given any error?
If I try to add a row with LOC, an index is added,
df8.loc[df8.index.max() + 1, :] = [4, 5, 6,7] print(df8)
result:
A B C D NaN 4 5 6 7
I guess neither LOC, nor iLOC could be used to append rows without index name (i.e. Loc adds the index name NaN, and iLoc can not be used when the index number is higher than the rows of the database)
-
Prashant almost 5 years"You need to assign the result back." was a life saver
-
cs95 over 3 years@SeanMcCarthy Where does it say that
df.append
works inplace? I have strong opinions on whetherinplace=True
is actually beneficial to the API or not. See here -
Sean McCarthy over 3 years@cs95 you're right. I was reading the example in the documentation wrong... my bad. In fact, it must be assigned to a variable, and cannot be done in-place. If it could be done in-place, there would likely be an argument of
inplace=True
as with other Pandas methods