Question

(a) Create a DataFrame df1 using a dict with country and medal as the keys and the two lists as corresponding values: ['United States', 'Great Britain', 'China', 'Russia', 'Germany', 'France', 'Japan'] and [121, 67, 70, 56, 42, 42, np.nan].

(b) Show the head of the DataFrame df1.

(c) Create another DataFrame df2 using the above dict, but with columns in the order ['medal', 'country', 'gold']. Display df2. See how gold column is filled with missing values.

(d) Retrieve the column country from the dataframe df2 using the dict-like notation. Check the type of the column.

(e) Retrieve the column country from the dataframe df2 using attribute notation.

(f) Create yet another DataFrame df3 using a different approach.

First create 2 lists country and medal as follows:

• country = ['United States', 'Great Britain', 'China', 'Russia', 'Germany', 'France', 'Japan']
• medal = [121, 67, 70, 56, 42, 42, np.nan]

Second, create a list of column labels called labels_list: ['country', 'medal']. Third, create another list columns_list which has 2 list items country and medal: [country, medal]. Next, create a dict using zipped lists labels_list and columns_list, and finally make a DataFrame df3 out of it. Then assign country as the index of the DataFrame. Display the dataframe df3.

(g) Practice again. Create another DataFrame with 3 elements using the approach in part (f).

Please help! This is a programming exercise for Python.

Answer 1