Pandas: Fixing Wrong Data

Wrong data is just a wrong data like if someone registered 90 instead of 9.0. 

 

• Replacing Values 

One way to fix wrong values is to replace them with something else. 

 

Example 

Set "Duration" = 80 in row 2. 

df.loc[2, 'Duration'] = 80

 

• Removing Rows

Another way of handling wrong data is to remove the rows that contains wrong data. 

Example 

Delete rows where "Duration" is higher than 130.

for x in df.index: 
	if df.loc[x, "Duration"] > 130: 
    df.drop(x, inplace = True)

 

Exercise

Loop through all values in the "Duration" column. If the value is higher than 120, set it to 120.

for x in df.index: 
	if df.loc[x, "Duration"] > 120: 
   	df.loc [x, "Duration"] = 120