#!/usr/bin/env python
# coding: utf-8
#
# DatatableTon
# 💯 datatable exercises
#
#
#
# 
#
#
# 
#
#
# 
#
#
#
# This is Set 2: Files and Formats (Exercises 11-20) 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+).
# * Additional packages `numpy`, `pandas` and `pyarrow` should be installed.
# * Small example values along with the sample dataset [datatableton_sample.zip](https://github.com/vopani/datatableton/blob/main/data/datatableton_sample.zip) 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('python3 -m pip install numpy')
get_ipython().system('python3 -m pip install pandas')
get_ipython().system('python3 -m pip install pyarrow')
get_ipython().system('wget https://raw.githubusercontent.com/vopani/datatableton/main/data/datatableton_sample.zip')
# In[2]:
import datatable as dt
import numpy as np
import pandas as pd
import pyarrow as pa
dtable = dt.Frame(f1=range(10), f2=['Y', 'O', 'U', 'C', 'A', 'N', 'D', 'O', 'I', 'T'])
dframe = pd.DataFrame({'v1': range(11), 'v2': ['N', 'E', 'V', 'E', 'R', 'G', 'I', 'V', 'E', 'U', 'P']})
nparray = np.array([[0, 'C'], [1, 'O'], [2, 'D'], [3, 'E']])
patable = pa.Table.from_pandas(dframe)
dlist = [range(4), ['D', 'A', 'T', 'A']]
ddict = {'x': range(6), 'y': ['P', 'Y', 'T', 'H', 'O', 'N']}
dtup = [(0, 'L'), (1, 'E'), (2, 'A'), (3, 'R'), (4, 'N')]
# **Exercise 11: Write `dtable` to a csv named `data.csv`, to a compressed gz csv named `data.gz` and to a jay named `data.jay`**
# In[ ]:
# **Exercise 12: Read `data.csv` and assign it to `data_csv`, read `data.gz` and assign it to `data_gz`, read `data.jay` and assign it to `data_jay`**
# In[ ]:
# In[ ]:
# In[ ]:
# **Exercise 13: Read data from this URL: [https://raw.githubusercontent.com/vopani/datatableton/main/data/datatableton_sample.csv](https://raw.githubusercontent.com/vopani/datatableton/main/data/datatableton_sample.csv) and assign it to `data_url`**
# In[ ]:
# **Exercise 14: Read `users.csv` from `datatableton_sample.zip` and assign it to `data_zip`**
# In[ ]:
# **Exercise 15: Create a dt.Frame `data_pd` from the pd.DataFrame `dframe` and create a pd.DataFrame `pd_data` from the dt.Frame `data_pd`**
# In[ ]:
# In[ ]:
# **Exercise 16: Create a dt.Frame `data_np` from the np.array `nparray` and create a np.array `np_data` from the dt.Frame `data_np`**
# In[ ]:
# In[ ]:
# **Exercise 17: Create a dt.Frame `data_ls` from the list `dlist` and create a list `ls_data` from the dt.Frame `data_ls`**
# In[ ]:
# In[ ]:
# **Exercise 18: Create a dt.Frame `data_dc` from the dictionary `ddict` and create a dictionary `dc_data` from the dt.Frame `data_dc`**
# In[ ]:
# In[ ]:
# **Exercise 19: Create a dt.Frame `data_tp` from the tuples `dtup` and create tuples `tp_data` from the dt.Frame `data_tp`**
# In[ ]:
# In[ ]:
# **Exercise 20: Create a dt.Frame `data_pa` from the pyarrow.Table `patable` and create a pyarrow.Table `pa_data` from the dt.Frame `data_pa`**
# In[ ]:
# In[ ]:
# ✅ This completes Set 2: Files and Formats (Exercises 11-20) of **DatatableTon**: *💯 datatable exercises*
#
# #### Set 03 • Data Selection • Beginner • Exercises 21-30
#
# | Style | Colab | Kaggle | Binder | GitHub |
# | ----- | ----- | ------ | ------ | ------ |
# | Exercises | [](https://colab.research.google.com/github/vopani/datatableton/blob/main/notebooks/03_data_selection_exercises.ipynb) | [](https://www.kaggle.com/rohanrao/datatableton-data-selection-exercises) | [](https://mybinder.org/v2/gh/vopani/datatableton/main?filepath=notebooks%2F03_data_selection_exercises.ipynb) | [](https://github.com/vopani/datatableton/blob/main/notebooks/03_data_selection_exercises.ipynb) |
# | Solutions | [](https://colab.research.google.com/github/vopani/datatableton/blob/main/notebooks/03_data_selection_solutions.ipynb) | [](https://www.kaggle.com/rohanrao/datatableton-data-selection-solutions) | [](https://mybinder.org/v2/gh/vopani/datatableton/main?filepath=notebooks%2F03_data_selection_solutions.ipynb) | [](https://github.com/vopani/datatableton/blob/main/notebooks/03_data_selection_solutions.ipynb) |
#
# You can find all the exercises and solutions on [GitHub](https://github.com/vopani/datatableton#exercises-)