#!/usr/bin/env python
# coding: utf-8
#
# DatatableTon
# 💯 datatable exercises
#
#
#
# 
#
#
# 
#
#
# 
#
#
#
# This is Set 3: Data Selection (Exercises 21-30) of DatatableTon: 💯 datatable exercises
#
# You can find all the exercises and solutions on GitHub
#
# **Prerequisites**
# * The `datatable` package should be upgraded to the latest version (or v1.0.0+).
# * The sample dataset [datatableton_sample.csv](https://github.com/vopani/datatableton/blob/main/data/datatableton_sample.csv) will be used for the exercises.
# In[1]:
get_ipython().system('python3 -m pip install -U pip')
get_ipython().system('python3 -m pip install -U datatable')
get_ipython().system('wget https://raw.githubusercontent.com/vopani/datatableton/main/data/datatableton_sample.csv')
# In[2]:
import datatable as dt
data = dt.fread('datatableton_sample.csv')
data
# **Exercise 21: Select the columns `user`, `product` and `quantity` from `data` and assign it to `data_upq` and select the `user` column from `data_upq` and assign it to `data_u`**
# In[ ]:
# In[ ]:
# **Exercise 22: Select columns 2nd to 4th using indices from `data` and assign it to `data_c234`**
# In[ ]:
# **Exercise 23: Select all string columns from `data` and assign it to `data_str`**
# In[ ]:
# **Exercise 24: Select rows 4th and 1st from `data` and assign it to `data_r41`**
# In[ ]:
# **Exercise 25: Select the element in the 4th row and 2nd column in `data` and assign it to `value_1` and select the 3rd element of `category` column in `data` and assign it to `value_2`**
# In[ ]:
# In[ ]:
# **Exercise 26: Select rows from `data` where `category` is `Fruit` and assign it to `data_fruit` and select rows from `data_fruit` where `product` is `Banana` and `quantity` is more than 1 and assign it to `data_multi_banana`**
# In[ ]:
# In[ ]:
# **Exercise 27: Select columns from `data` that have no missing values and assign it to `data_nomissing_cols`**
# In[ ]:
# **Exercise 28: Select rows from `data` that have no missing values and assign it to `data_nomissing_rows`**
# In[ ]:
# **Exercise 29: Select unique rows from `data` and assign it to `data_unique` and select unique `product` from `data_unique` and assign it to `product_unique`**
# In[ ]:
# In[ ]:
# **Exercise 30: Select first row of each user from `data` and assign it to `data_first`**
# In[ ]:
# ✅ This completes Set 3: Data Selection (Exercises 21-30) of **DatatableTon**: *💯 datatable exercises*
#
# #### Set 04 • Frame Operations • Beginner • Exercises 31-40
#
# | Style | Colab | Kaggle | Binder | GitHub |
# | ----- | ----- | ------ | ------ | ------ |
# | Exercises | [](https://colab.research.google.com/github/vopani/datatableton/blob/main/notebooks/04_frame_operations_exercises.ipynb) | [](https://www.kaggle.com/rohanrao/datatableton-frame-operations-exercises) | [](https://mybinder.org/v2/gh/vopani/datatableton/main?filepath=notebooks%2F04_frame_operations_exercises.ipynb) | [](https://github.com/vopani/datatableton/blob/main/notebooks/04_frame_operations_exercises.ipynb) |
# | Solutions | [](https://colab.research.google.com/github/vopani/datatableton/blob/main/notebooks/04_frame_operations_solutions.ipynb) | [](https://www.kaggle.com/rohanrao/datatableton-frame-operations-solutions) | [](https://mybinder.org/v2/gh/vopani/datatableton/main?filepath=notebooks%2F04_frame_operations_solutions.ipynb) | [](https://github.com/vopani/datatableton/blob/main/notebooks/04_frame_operations_solutions.ipynb) |
#
# You can find all the exercises and solutions on [GitHub](https://github.com/vopani/datatableton#exercises-)