Exercises.ipynb

Kernel: Python [default]

Wine

Introduction:

This exercise is a adaptation from the UCI Wine dataset. The only pupose is to practice deleting data with pandas.

Step 1. Import the necessary libraries

Step 2. Import the dataset from this address.

Step 3. Assign it to a variable called wine

Step 4. Delete the first, fourth, seventh, nineth, eleventh, thirteenth and fourteenth columns

Step 5. Assign the columns as below:

The attributes are (donated by Riccardo Leardi, riclea '@' anchem.unige.it):

1. alcohol

2. malic_acid

3. alcalinity_of_ash

4. magnesium

5. flavanoids

6. proanthocyanins

7. hue

Step 6. Set the values of the first 3 rows from alcohol as NaN

Step 7. Now set the value of the rows 3 and 4 of magnesium as NaN

Step 8. Fill the value of NaN with the number 10 in alcohol and 100 in magnesium

Step 9. Count the number of missing values

Step 10. Create an array of 10 random numbers up until 10

Step 11. Use random numbers you generated as an index and assign NaN value to each of cell.

Step 12. How many missing values do we have?

Step 13. Delete the rows that contain missing values

Step 14. Print only the non-null values in alcohol

Step 15. Reset the index, so it starts with 0 again

BONUS: Create your own question and answer it.