'Need to add row above the headers of Dataframe in pandas

I have a dataframes, I need to add 8 rows above the header of dataframe, I am sharing dataframe and the desired output

Dataframe:-

   Toll     No.     Vr.name
   245      2487    XR
   145      3754    MY
   55       7356    DF
   65       4487    DF
   28       7785    MY
   47       8235    XR
   87       2468    PQ
   75       9735    GR
   98       6486    TY
   240      1023    PQ

rows need to be added

    Car      8425
    Booth No 24
    Toll TR. Mr.XYZ
    Date     05-JAN-22
    Amt      123
    Time     11:02:01
    Mode     QR
    Tag      YES

What Needed :-

  1. Want to add rows in dataframe above the header of dataframe.
  2. No. of rows may increase in some cases.

Desired Output

   Car      8425
   Booth No 24
   Toll TR. Mr.XYZ
   Date     05-JAN-22
   Amt      123
   Time     11:02:01
   Mode     QR
   Tag      YES

   Toll     No.     Vr.name
   245      2487    XR
   145      3754    MY
   55       7356    DF
   65       4487    DF
   28       7785    MY
   47       8235    XR
   87       2468    PQ
   75       9735    GR
   98       6486    TY
   240      1023    PQ


Solution 1:[1]

I made a separate datframe of rows, now I have two dataframes.

DF -

    Car      8425
    Booth No 24
    Toll TR. Mr.XYZ
    Date     05-JAN-22
    Amt      123
    Time     11:02:01
    Mode     QR
    Tag      YES

DF2:-

   Toll     No.     Vr.name
   245      2487    XR
   145      3754    MY
   55       7356    DF
   65       4487    DF
   28       7785    MY
   47       8235    XR
   87       2468    PQ
   75       9735    GR
   98       6486    TY
   240      1023    PQ

Code to add both dataframe in CSV :-

with open((file_name), 'w',newline='') as f:
    writer = csv.writer(f)
    for index,row in df.iterrows():
       writer.writerow(row)
    writer.writerow(New_out)
    for index1,row1 in df2.iterrows():
       writer.writerow(row1)

I directly write both the dataframe in CSV file.

Outtput I got:-

   Car      8425
   Booth No 24
   Toll TR. Mr.XYZ
   Date     05-JAN-22
   Amt      123
   Time     11:02:01
   Mode     QR
   Tag      YES
   Toll     No.     Vr.name
   245      2487    XR
   145      3754    MY
   55       7356    DF
   65       4487    DF
   28       7785    MY
   47       8235    XR
   87       2468    PQ
   75       9735    GR
   98       6486    TY
   240      1023    PQ

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Mohit