how do I insert a column at a specific column index in pandas?

by

see docs: http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.insert.html

using loc = 0 will insert at the beginning

df.insert(loc, column, value)

df = pd.DataFrame({'B': [1, 2, 3], 'C': [4, 5, 6]})

df
Out: 
   B  C
0  1  4
1  2  5
2  3  6

idx = 0
new_col = [7, 8, 9]  # can be a list, a Series, an array or a scalar   
df.insert(loc=idx, column='A', value=new_col)

df
Out: 
   A  B  C
0  7  1  4
1  8  2  5
2  9  3  6

More Related Contents:

  1. How are iloc and loc different?
  2. How to convert index of a pandas dataframe into a column
  3. pandas loc vs. iloc vs. at vs. iat?
  4. How to reset index in a pandas dataframe? [duplicate]
  5. What rules does Pandas use to generate a view vs a copy?
  6. Pandas split DataFrame by column value
  7. Selecting a row of pandas series/dataframe by integer index
  8. How to avoid Python/Pandas creating an index in a saved csv?
  9. What is the difference between using squared brackets or dot to access a column?
  10. What is the performance impact of non-unique indexes in pandas?
  11. Python Pandas: Get index of rows which column matches certain value
  12. Remove index name in pandas
  13. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  14. What is the point of indexing in pandas?
  15. Python pandas slice dataframe by multiple index ranges
  16. Update row values where certain condition is met in pandas
  17. How to query MultiIndex index columns values in pandas
  18. Get column index from column name in python pandas
  19. How to avoid pandas creating an index in a saved csv
  20. Python Pandas: Get index of rows where column matches certain value
  21. Selecting pandas column by location
  22. Pandas max value index
  23. Get first row value of a given column
  24. Python: Removing Rows on Count condition
  25. Using replace efficiently in pandas
  26. In Python pandas, start row index from 1 instead of zero without creating additional column
  27. Selecting a range of columns in a dataframe
  28. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  29. What’s the alternative to pandas chain indexing?
  30. start index at 1 for Pandas DataFrame

Leave a Comment