Insert Row at Specific Position of pandas DataFrame in Python (Example) | Add & Append New Data Line

Python code of this video:

import pandas as pd # Load pandas library

my_data = pd.DataFrame({"x1":["a", "b", "c", "b"], # Create pandas DataFrame
"x2":range(16, 20),
"x3":range(1, 5),
"x4":["a", "b", "c", "d"]})
print(my_data) # Print pandas DataFrame

my_row = [11, 22, 33, 44] # Create list
print(my_row) # Print list

print(data_new) # Print updated DataFrame

Follow me on Social Media:

[markmusk]

It's very helpful, thank you very much.

[davidwisemantel]

Thanks, easy to follow this. What about if you wanted to insert a blank row at a specific index?

[preetig]

Want to add empty row above the headers of the existing table, in order to merge cells and create new headers. Could you please help how we can achieve that?

[avirajankitjain]

i want to insert one column name Serial_No and want to add number from 1 to 100 in a pre-existing data frame. how to do that?

[jyotibala]

Hi, how to add empty row at any position in dataframe and what does 1.5 mean in loc method?Thanks in advance.

[jesuslopez]

This trick is fucking amazing! Thanks for sharing!!!