Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to append a list to dataframe without using column names?

Tags:

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?

like image 599
Rahul Rai Avatar asked Apr 05 '19 18:04

Rahul Rai


People also ask

Can you append a list to a DataFrame?

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.


1 Answers

You can do something like

df.loc[len(df)] = [1, 2, 3, 4]
like image 133
Slayer Avatar answered Oct 09 '22 20:10

Slayer