<jupyter_start><jupyter_text>Crypto Data Download<jupyter_code>%config IPCompleter.greedy=True
# Initial imports
import requests
import json
import numpy as np
import pandas as pd
from pathlib import Path<jupyter_output><empty_output><jupyter_text>Fetching Cryptocurrency Data<jupyter_code>headers = {
    'Connection': 'keep-alive',
    'Pragma': 'no-cache',
    'Cache-Control': 'no-cache',
    'Upgrade-Insecure-Requests': '1',
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.66 Safari/537.36',
    'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9',
    'Sec-Fetch-Site': 'cross-site',
    'Sec-Fetch-Mode': 'navigate',
    'Sec-Fetch-User': '?1',
    'Sec-Fetch-Dest': 'document',
    'Accept-Language': 'en-US,en;q=0.9',
}

response = requests.get('https://min-api.cryptocompare.com/data/all/coinlist', headers=headers)
json_data = json.loads(response.text)<jupyter_output>IOPub data rate exceeded.
The notebook server will temporarily stop sending output
to the client in order to avoid crashing it.
To change this limit, set the config variable
`--NotebookApp.iopub_data_rate_limit`.

Current values:
NotebookApp.iopub_data_rate_limit=1000000.0 (bytes/sec)
NotebookApp.rate_limit_window=3.0 (secs)<jupyter_text>Transforming JSON to Dataframe<jupyter_code># Creating a DataFrame (which needed to be transposed)
crypto_df = pd.DataFrame(json_data['Data']).T
crypto_df.head()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.1434010152284264, 'fraction_numerical': 0.031091370558375634, 'mean_word_length': 5.797413793103448, 'pattern_counts': {'":': 0, '<': 12, '<?xml version=': 0, '>': 12, 'https://': 1, 'lorem ipsum': 0, 'www.': 0, 'xml': 2}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 1, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '3', 'dir': 'jupyter-structured-clean-dedup', 'id': '489908', 'license': 'MIT', 'n_tokens_mistral': 600, 'n_tokens_neox': 572, 'n_words': 111, 'path': 'crypto_data_download.ipynb', 'repo_name': 'FranciscoSerrano/cyptocurrencies', 'size': '1576'}