Asume that I have the following dataframe:
d = {'col1': [1, 2], 'col2': [3, 4]}
df = pd.DataFrame(data=d)
I would like to extend col1
with array xtra
. However this errors out.
xtra = [3,4]
df['col1'].append(xtra)
How can I append xtra
to df.col1
, so that the final otuput would looks as so?
col1 col2
0 1 3
1 2 4
2 3 nan
3 4 nan
just copy the same format you used (dict
) to make a dataframe like so:
import pandas as pd
d = {'col1': [1, 2], 'col2': [3, 4]}
df = pd.DataFrame(data=d)
xtra = {'col1': [3,4]}
df = df.append(pd.DataFrame(xtra))
Use pd.DataFrame
and DataFrame.append
:
df = df.append(pd.DataFrame(xtra, columns=['col1']), ignore_index=True)
print(df)
col1 col2
0 1 3.0
1 2 4.0
2 3 NaN
3 4 NaN
You can also add those rows without creating annother Dataframe by iterating on xtra:
for val in xtra:
df = df.append({'col1' : val}, ignore_index=True)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With