Want to get result as explained below but not getting the desired result.
Tried .update but failed. The last_row should be placed in blank row in its column.
given:::>
import pandas as pd
d1 = {
'a': [10],
'b': [20],
'c': [30],
'q': "",
'w': "",
'e': ""
}
df1 = pd.DataFrame(d1)
print(df1)
d2 = {
'q': [7,40],
'w': [8,50],
'e': [9,60]
}
df2 = pd.DataFrame(d2)
print(df2)
last_row = df2.tail(1)
print(last_row)
expected result:::>
result = {
'a': [10],
'b': [20],
'c': [30],
'q': [40],
'w': [50],
'e': [60]
}
df_result = pd.DataFrame(result)
print(df_result)
Need same index:
df1.update(last_row.reset_index(drop=True))
print (df1)
a b c q w e
0 10 20 30 40 50 60