Is it possible to insert a row at an arbitrary position in a dataframe using pandas?

by

You could slice and use concat to get what you want.

line = DataFrame({"onset": 30.0, "length": 1.3}, index=[3])
df2 = concat([df.iloc[:2], line, df.iloc[2:]]).reset_index(drop=True)

This will produce the dataframe in your example output. As far as I’m aware, concat is the best method to achieve an insert type operation in pandas, but admittedly I’m by no means a pandas expert.

More Related Contents:

  1. error when applying function to a series object
  2. How to group dataframe rows into list in pandas groupby
  3. Groupby value counts on the dataframe pandas
  4. Replace values in a pandas series via dictionary efficiently
  5. Pandas: Chained assignments [duplicate]
  6. Apply pandas function to column to create multiple new columns?
  7. Reading an Excel file in python using pandas
  8. Python Pandas: Get index of rows which column matches certain value
  9. Python: Convert timedelta to int in a dataframe
  10. How to insert pandas dataframe via mysqldb into database?
  11. Pandas make new column from string slice of another column
  12. Update a dataframe in pandas while iterating row by row
  13. SQLAlchemy ORM conversion to pandas DataFrame
  14. Conditionally format Python pandas cell
  15. import csv with different number of columns per row using Pandas
  16. Selecting columns from pandas MultiIndex
  17. How to concatenate multiple column values into a single column in Pandas dataframe
  18. Get week start date (Monday) from a date column in Python (pandas)?
  19. Python Pandas write to sql with NaN values
  20. Pandas style function to highlight specific columns
  21. pandas.io.json.json_normalize with very nested json
  22. Python pandas convert datetime to timestamp effectively through dt accessor
  23. Checking if particular value (in cell) is NaN in pandas DataFrame not working using ix or iloc
  24. Time Series Analysis – unevenly spaced measures – pandas + statsmodels
  25. Move column by name to front of table in pandas
  26. matplotlib savefig() size control
  27. Is there a way to speed up handling large CSVs and dataframes in python?
  28. Can you format pandas integers for display, like `pd.options.display.float_format` for floats?
  29. computing the mean for python datetime
  30. Pandas explode multiple columns [duplicate]

Leave a Comment