A quick challenge to read a csv in python and export it...
You will need python and the package pandas to complete this challenge. How you choose to set this up is up to you.
-
Use python and pandas to read "cereals.csv" provided in this repo (n.b. the files isn't separated by commas!)
-
Print the column names and take a screenshot
-
Change the datatype of the column 'rating' to integer
-
Export the dataframe to a new csv called "cleaned_cereals.csv"
-
(optional) Split the csv into 2 separated csvs, called:
- split1_cereal.csv
- split2_cereal.csv
Fork this repository and add your files to a folder with your name on it. The required files are :
- cleaned_cereals.csv
- Screenshot of column names
- (optional) Additional pair of split csvs
Then to submit, create a pull request to merge.