1.03_activity_1.md

1.03 Activity 1

Refer to the folder files_for_activities for this exercise. You can continue using the same jupyter notebook that you craeted in class (where you worked on file1 and file2). Please save your work (jupyter notebook) as we will build on the same activities later.

1. Load data (file3.xlsx and file4.xlsx) in a new Jupyter notebook. You might face the error saying that optional dependency xlrd is missing. In that case, they should install it using pip. If you don't get the error, move to the next step. 😄
2. Print data columns for both files.
3. Check the names and order of columns in the files, and compare them with the "data" DataFrame created in class.
4. Change the names of required columns in the new dataframes read before concatenating the files with data.
5. Change data columns from uppercase to lowercase.

We will merge the dataframes in the next exercise