Q:

Clean the dataset and update the CSV file using python programming

belongs to collection: Python Pandas Exercises

YasminRadwan26
Save to bookmark
|
2022-05-05
|
  193 
0

Clean the dataset and update the CSV file

Replace all column values which contain ?, n.a, or NaN.

Python programming,
login and add your own answer to this question

All Answers

YasminRadwan26
2022-05-05
need an explanation for this answer? contact us directly to get an explanation for this answer

Solution:

df = pd.read_csv("D:\\Python\\Articles\\pandas\\automobile-dataset\\Automobile_data.csv", na_values={
'price':["?","n.a"],
'stroke':["?","n.a"],
'horsepower':["?","n.a"],
'peak-rpm':["?","n.a"],
'average-mileage':["?","n.a"]})
print (df)

df.to_csv("D:\\Python\\Articles\\pandas\\automobile-dataset\\Automobile_data.csv")

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Python Pandas Exercises
This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now
Find the most expensive car company name using pyt... >>
<< From the given dataset print the first and last fi...