change column name in pandas, which will be used to change name for 1 column

by 
df.loc[((df.SPIN == 'COR') | (df.SPIN == r'F/R')), 'MTM'] = (df["MARKET PRICE"] - df["TRADE PRICE"]) * (
df["QTY"] / 100)
df.rename(columns={'MTM': 'Market to Market'}, inplace=True)
reportName = "Output"
reportFileOut = rptDirPath + '\\' + reportName + '.xlsx'
writer = pd.ExcelWriter(reportFileOut)
df.to_excel(writer, 'Sheet1')
writer.save()

More Related Contents:

  1. Convert columns into rows with Pandas
  2. Pandas – How to flatten a hierarchical index in columns
  3. How to write to an existing excel file without overwriting data (using pandas)?
  4. How to pass another entire column as argument to pandas fillna()
  5. Change one value based on another value in pandas
  6. Sorting columns in pandas dataframe based on column name [duplicate]
  7. Pandas ‘count(distinct)’ equivalent
  8. What is the performance impact of non-unique indexes in pandas?
  9. What is the difference between using loc and using just square brackets to filter for columns in Pandas/Python?
  10. Pandas: Cast column to string does not work
  11. How to query MultiIndex index columns values in pandas
  12. How to convert column with dtype as object to string in Pandas Dataframe [duplicate]
  13. Python – splitting dataframe into multiple dataframes based on column values and naming them with those values [duplicate]
  14. Remove non-ASCII characters from pandas column
  15. Add multiple empty columns to pandas DataFrame
  16. No numeric types to aggregate – change in groupby() behaviour?
  17. OSError: Initializing from file failed on csv in Pandas
  18. Line plot with data points in pandas
  19. Python & Pandas: How to query if a list-type column contains something?
  20. Remove Unnamed columns in pandas dataframe [duplicate]
  21. Datetime conversion – How to extract the inferred format?
  22. Python numpy: cannot convert datetime64[ns] to datetime64[D] (to use with Numba)
  23. Efficient way to add rows to dataframe
  24. Slicing multiple ranges of columns in Pandas, by list of names
  25. Find names of top-n highest-value columns in each pandas dataframe row
  26. Changing certain values in multiple columns of a pandas DataFrame at once
  27. Round float columns in pandas dataframe
  28. Converting PANDAS dataframe from monthly to daily
  29. Pandas datetimes with different formats in the same column
  30. Get max value from row of a dataframe in python [duplicate]

Leave a Comment