File conversion and summary statistics with csvkit
It's common for Excel data files to have more than one worksheet (tab) of data. The Excel file SpotifyData.xlsx has two sheets named Worksheet1_Popularity and Worksheet2_MusicAttributes. Each sheet should be treated like its own data file, so we will use csvkit's commands here to convert each sheet to its own CSV file. Then, using the power of the commands we already know, print a high level summary for each column in the CSV files.
Bu egzersiz, kursun bir parçasıdır
Data Processing in Shell
Uygulamalı etkileşimli egzersiz
Bu egzersizi bu örnek kodu tamamlayarak deneyin.
# Check to confirm name and location of the Excel data file
ls
# Convert sheet "Worksheet1_Popularity" to CSV
___ SpotifyData.xlsx ___ "Worksheet1_Popularity" > Spotify_Popularity.csv