The following topics are covered in the quiz:

- Working with categorical data
- Handling missing and duplicate data
- Transforming data with type-specific functions
- Data frame concatenation and merging

Advanced Data Analysis Techniques

Match the following commands to their working.

1. ls 

2. l 

3. h 

4. wc 


a. Check the length of the file using the __ terminal command

b. __ to list the contents of the current directory

c. __ displays more information about your files and folder 

d. __ makes the displayed filesize numbers human-readable


What is the working of the command `%%time`?

Match the following 

1. `head()`  2. `tail()`  3. `info()` 4. `describe()`

a. Returns bottom n rows of a data frame or series

b. Returns the top n rows of a data frame or series

c. Computes and displays summary statistics for a data frame

d. Prints information about the data frame


Which of the following techniques are used to handle large datasets?

Why is it preferred to use feather, parquet files instead of CSV files?

Choose the correct statements on Dask.

Which of the following statements are true about `memory_usage()`?

For the given data frame, match the following syntax to their results.

<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/4&cellId=2&hideInput=true" title="Jovian Viewer" height="380" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

1. `jovian_notebooks['Notebook'].unique()`

2. `jovian_notebooks['Notebook'].nunique()`

3. `jovian_notebooks['Notebook'].count()`

4. `jovian_notebooks['Notebook'].value_counts()`

a. `array(['Python Programming', 'Statistics', 'Data Anaylsis',
       'Data Visualization', 'Machine Learning', 'Excel', 'Tableau'],
      dtype=object)`

b. `7` 

c. `10`

d.

<code> Python Programming    2 </code>

<code> Statistics            2 </code>

<code> Excel                 2 </code>

<code> Data Anaylsis         1 </code>

<code> Data Visualization    1 </code>

<code> Machine Learning      1 </code>

<code> Tableau               1 </code>

<code> Name: Notebook, dtype: int64 </code>

Choose the correct syntax for converting a column's datatype.

What is one hot encoding?

Match the most appropriate encoding technique to a scenario:

1. When the categorical feature is ordinal (suitable for encoding variables where alphabetical alignment or numerical value of labels is important)

2. When the features are nominal (creating a column for each category present in the feature and assigning a 1 or 0 to indicate the presence of a category in the data)

3. Similar to one-hot encoding. Uses N-1 features to represent N labels/categories. 

a. Label encoding

b. One-hot encoding 

c. Dummy encoding

Choose the correct syntax for dropping missing values of a data frame:



Choose the correct statements about `get_dummies()` from the following.

Given dataframes `df1` & `df2`. 

`df1`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/6&cellId=21&hideInput=true" title="Jovian Viewer" height="221" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

`df2`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/6&cellId=22&hideInput=true" title="Jovian Viewer" height="221" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

What is the output of the resulting code?

`pd.concat([df1, df2], axis=1)`

Given the data frame df, match the following syntax to their results

`df`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=25&hideInput=true" title="Jovian Viewer" height="327" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

1. `df.isna().dropna()`

2. `df.fillna(0)`

3. `df.dropna()`

4. `df.notna()`

a. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/28&cellId=32&hideInput=true" title="Jovian Viewer" height="327" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

b. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=31&hideInput=true" title="Jovian Viewer" height="115" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

c. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=30&hideInput=true" title="Jovian Viewer" height="327" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

d. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=29&hideInput=true" title="Jovian Viewer" height="327" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

Choose the correct syntax for checking duplicates in a data frame.

Which of the follow method is used to remove duplicate rows from a DataFrame?

For the given data frame, match the following arithmetic operations with the results

`jovian_notebooks`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=2&hideInput=true" title="Jovian Viewer" height="418" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

1. `np.power(jovian_notebooks['Likes'],2)`

2. `np.sqrt(jovian_notebooks['Likes'])`

3. `np.multiply(jovian_notebooks['Likes'],2)`

4. `jovian_notebooks['Likes']`

a. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=76&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

b. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=74&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

c. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=77&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

d. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=72&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

For the given data frame, match the following string operations with the results

`jovian_notebooks`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=2&hideInput=true" title="Jovian Viewer" height="418" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

1. `jovian_notebooks.Notebook.str.lower()`

2. `jovian_notebooks.Notebook.str.split(' ')`

3. `jovian_notebooks.Notebook.str.replace('Statistics', 'Statistics for Data Science')`

4. `jovian_notebooks.Notebook.str.contains("Statistics")`

a. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=35&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

b. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=36&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

c. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=37&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

d. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/8&cellId=38&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

For the following data frame, Match the following datetime syntax to their result

`jovian_notebooks`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/29&cellId=33&hideInput=true" title="Jovian Viewer" height="380" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

1. `jovian_notebooks['Year'].dt.date`

2. `jovian_notebooks['Year'].dt.day`

3. `jovian_notebooks['Year'].dt.month`

4. `jovian_notebooks['Year'].dt.year`

a. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/9&cellId=5&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

b. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/9&cellId=3&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

c. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/9&cellId=6&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

d. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/9&cellId=4&hideInput=true" title="Jovian Viewer" height="290" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

e. IndexError

Choose the correct syntax for date string.


Match the following definitions to their functions


1. Built-in function that allows you to process and transform all the items in an iterable without using an explicit for loop

2. Method that allows you to apply a function along one of the axis of the DataFrame, default 0, which is the index (row) axis

3. Function that is used to apply a function to a Dataframe elementwise

a. map()

b. applymap()

c. apply()

What are the differences between map, apply and applymap methods? Choose the correct statements. 

What are the differences between concat and append? Choose the correct statements.

For the given data frames, match the following concat syntax to their results

`df2`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/9&cellId=26&hideInput=true" title="Jovian Viewer" height="221" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

`df3`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/10&cellId=5&hideInput=true" title="Jovian Viewer" height="221" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>


1. `pd.concat([df3, df2], axis=1,join='outer')`

2. `pd.concat([df2, df3], axis=1,join='outer')`

3. `pd.concat([df2, df3], axis=0)`

4. `pd.concat([df3, df2], axis=0)`

5. `pd.concat([df2, df3], axis=1,join='inner')`

a. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/10&cellId=49&hideInput=true" title="Jovian Viewer" height="327" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

b. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/10&cellId=47&hideInput=true" title="Jovian Viewer" height="327" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

c. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/10&cellId=52&hideInput=true" title="Jovian Viewer" height="115" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

d. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/pankajthakur3999/advanced-data-analysis-pandas/v/13&cellId=248" title="Jovian Viewer" height="354" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

e. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/10&cellId=50&hideInput=true" title="Jovian Viewer" height="327" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

For the given data frames, match the following merge syntax to their results

`left`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/11&cellId=6&hideInput=true" title="Jovian Viewer" height="221" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

`right`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/11&cellId=7&hideInput=true" title="Jovian Viewer" height="221" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>


1. `pd.merge(left, right, how="inner", on="key")`

2. `pd.merge(right, left, how="inner", on="key")`

3. `pd.merge(right, left, how="outer", on="key")`

4. `pd.merge(left, right, how="outer", on="key")`

a. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/prasanthi-vvit/advanced-data-analysis-pandas-42241/v/1&cellId=273&hideInput=true" title="Jovian Viewer" height="165" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

b. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/prasanthi-vvit/advanced-data-analysis-pandas-42241/v/2&cellId=275&hideInput=true" title="Jovian Viewer" height="267" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

c. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/pankajthakur3999/advanced-data-analysis-pandas/v/15&cellId=272&hideInput=true" title="Jovian Viewer" height="165" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

d. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/prasanthi-vvit/advanced-data-analysis-pandas-42241/v/2&cellId=274&hideInput=true" title="Jovian Viewer" height="267" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

For the given data frames, match the following merge syntax to their results

`left`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/11&cellId=6&hideInput=true" title="Jovian Viewer" height="221" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

`right`
<iframe src="https://jovian.ai/embed?url=https://jovian.ai/samanvitha/quiz-c39b8/v/11&cellId=7&hideInput=true" title="Jovian Viewer" height="221" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

1. `pd.merge(left, right, how="left", on="key")`

2. `pd.merge(right, left, how="left", on="key")`

3. `pd.merge(right, left, how="right", on="key")`

4. `pd.merge(left, right, how="right", on="key")`

a. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/pankajthakur3999/advanced-data-analysis-pandas/v/15&cellId=281&hideInput=true" title="Jovian Viewer" height="216" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

b. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/pankajthakur3999/advanced-data-analysis-pandas/v/15&cellId=274&hideInput=true" title="Jovian Viewer" height="216" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

c. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/pankajthakur3999/advanced-data-analysis-pandas/v/15&cellId=273&hideInput=true" title="Jovian Viewer" height="216" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>

d. <iframe src="https://jovian.ai/embed?url=https://jovian.ai/pankajthakur3999/advanced-data-analysis-pandas/v/15&cellId=282&hideInput=true" title="Jovian Viewer" height="216" width="100%" style="margin 0 auto; max-width: 800px;" frameborder="0" scrolling="auto"></iframe>