Workflow =>
- Read CSV file and get Unit Price column data
- Convert column data price and create a new column as name ‘Fabric’
- save the output as xlsx
Sample:
Unit Price ---------- 330 350 380 I want to convert this data Fabric ------ Card Combed Viscos
My code:
##Fabric Data getFabric = df_new['Unit Price'] result = [] for fabric in getFabric: if fabric == 310: result.append("Card") elif fabric == 330: result.append("Combed Dawah") elif fabric == 350: result.append("Combed Regular") elif fabric == 490: result.append("Viscos") elif fabric == 550: result.append("Pleated") else: result.append(fabric) df_new['Fabric'] = result
Error :
Advertisement
Answer
Insted of iterating column value. Try this,
pandas built-in function called .replace()
is useful for replacing the value in the column without iteration throung it
df_new['Unit Price'].replace({310: 'Card', 330: 'Combed Dawah', 350: 'Combed Regular', 490: 'Viscos', 550: 'Pleated'}, inplace=True)
Above code will successfully relace the dataframe column values inplace.