I want to append a list of four prices [1, 2, 3, 4]
to an already existing dataframe using the DataFrame.append()
, the already existing dataframe has four columns.
Using this
dataframe = pd.DataFrame(columns=["open", "high", "low", "close"],
data = [[1, 2, 3, 4]])
Creates the dataframe
open high low close
0 1 2 3 4
Then I want to append some lists like this:
dataframe = dataframe.append([[5, 6, 7, 8]],
ignore_index =True)
Gives the output
open high low close 0 1 2 3
0 1.0 2.0 3.0 4.0 NaN NaN NaN NaN
1 NaN NaN NaN NaN 5.0 6.0 7.0 8.0
While I want the list to be appended in continuation to the dataframe, is there a way to do this without using the column names, only the list of four prices?
Using loc[] to Append The New List to a DataFrame. By using df. loc[index]=list you can append a list as a row to the DataFrame at a specified Index, In order to add at the end get the index of the last record using len(df) function.
You can do something like
df.loc[len(df)] = [1, 2, 3, 4]
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