Get startedGet started for free

Data processing with csvkit

Once we have assembled a dataset, we still need to process and clean the data prior to more advanced analysis such as predictive modeling. In this capstone exercise, let's make use of various commands in csvkit for some common data processing and cleaning.

The Excel file Spotify_201809_201810.xlsx contains two sheets (tabs), named Spotify201809 and Spotify201810. First, we will split the Excel file down to its individual sheets, preview summary statistics, remove some columns, and then stack the two sheets back together again to form one single csv file, ready for further analysis.

This exercise is part of the course

Data Processing in Shell

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Convert the Spotify201809 sheet into its own csv file 
___ Spotify_201809_201810.xlsx ___ ___ ___ Spotify201809.csv

# Check to confirm name and location of data file
ls
Edit and Run Code