Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 How modify the DataFrame columns
#1
Hi,
I have below DataFrame,
I want to add in "0th" row if the columns are STD, the modify the "0th" row as the:
original cell value +"STD:JPEG:"
and if the column is "Peak" then modify the cell value in "0th" row as:
original cell value +"Peak:JPEG:"
I use the below code, but it is adding multiple time. For example, STD is in three columns, the cell value is modifying as:
"CplSTD:JPEG:STD:JPEG:STD:JPEG:" but it should be: CplSTD:JPEG

My input data:
Name	Category	STD			        Peak	
Name	Category	Cpl	BNP	Regulator	Power	Voltage
HAJ	RT	44	6	12	45	34
LKO	SP	4	34	33	13	122
STD is merged for three columns, and Peak is merged for two columns.

import pandas as pd

df=pd.read_excel(r'D:\PythonCodes\jpeginput.xlsx')
df.rename( columns={'Unnamed: 3':'STD'}, inplace=True )
df.rename( columns={'Unnamed: 4':'STD'}, inplace=True )
df.rename( columns={'Unnamed: 3':'STD'}, inplace=True )
df.rename( columns={'Unnamed: 6':'Peak'}, inplace=True )

for i in range(len(list(df.columns))):
    if df.columns[i] == 'Name' or df.columns[i] == 'Category':
        print('skipped')
        print(df.columns[i])
    elif(df.columns[i] == 'STD'):
        df.loc[0,df.columns[i]] = df.loc[0,df.columns[i]]+"STD:JPEG:"
        print(df.columns[i])
    elif(df.columns[i] == 'Peak'):
        df.loc[0,df.columns[i]] = df.loc[0,df.columns[i]]+"Peak:JPEG:"
        print(df.columns[i])
    else:
        print('skipped')
        print(df.columns[i])


Quote
#2
Not entirely sure what you're trying to do here, but something like this should work:

import pandas as pd
df = pd.DataFrame(columns=['Name','Category','STD'])
df = df.append({'Name': 'HAJ', 'Category': 'RT', 'STD': 'Cpl'}, ignore_index=True)
df
df.iloc[0]['STD'] = df.iloc[0]['STD'] + 'STD:JPEG'
df
Quote
#3
If the column is STD, then I want to add in each cell (columns belongs to STD) of 0th row "The cell value + STD +JPEG"
If the column is Peak, then add to each cell (columns belongs to Peak) in 0th row "The cell value +Peak+JPEG"
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  DataFrame: To print a column value which is not null out of 5 columns mani 2 128 Mar-18-2020, 06:07 AM
Last Post: mani
Question Dividing a single column of dataframe into multiple columns based on char length darpInd 2 154 Mar-14-2020, 09:19 AM
Last Post: scidam
  Interate for loop over certain columns in dataframe Finpyth 2 142 Mar-06-2020, 08:34 AM
Last Post: Finpyth
  newbie: loop, modify dataframe cells expat_th 5 213 Mar-03-2020, 09:05 PM
Last Post: jefsummers
  How to highlight dataframe columns SriRajesh 1 149 Feb-28-2020, 11:02 PM
Last Post: Marbelous
  Does the order of columns in the DataFrame matter? new_to_python 11 363 Feb-17-2020, 12:32 AM
Last Post: scidam
  Pandas dataframe columns collapsed in Spyder when printing UniKlixX 2 392 Nov-04-2019, 07:00 AM
Last Post: UniKlixX
  Double 'for' loop and writing in a new columns dataframe marco_ita 0 318 Sep-07-2019, 12:44 PM
Last Post: marco_ita
  Creating A List of DataFrames & Manipulating Columns in Each DataFrame firebird 1 332 Jul-31-2019, 04:04 AM
Last Post: scidam
  [pandas] How to re-arrange DataFrame columns SriMekala 8 1,301 Jun-22-2019, 12:55 AM
Last Post: scidam

Forum Jump:


Users browsing this thread: 1 Guest(s)