Search code examples
pythonpandasdataframerowmultiple-columns

How to insert multiple rows in a dataframe in python without changing the Index?


I have a dataframe , How can i insert a row with Twith multiple values such that the index always starts with 0.

df:

   Topics_numberrs_k    Topics_assignment_k
0   0                   Int64Index([ 175, 920, 1016, 2068, 2162, 3385]
1   1                   Int64Index([ 2, 5, 6, 7, 8, 9]

Expected output:

    Topics_numberrs_k   Topics_assignment_k
0   -1                  NaN
1    0                  Int64Index([ 175, 920, 1016, 2068, 2162, 3385]
2    1                  Int64Index([ 2, 5, 6, 7, 8, 9]

Solution

  • Try:

    i_row = [-1, "NaN"]
    
    df.iloc[0] = i_row
    df