<jupyter_start><jupyter_text>01 - Getting and knowing your Data  Step 1. Import the necessary libraries.<jupyter_code>import pandas as pd
import numpy as np
import sys as ss<jupyter_output><empty_output><jupyter_text>Step 2. Import the data `food_100.csv` called it `food`<jupyter_code>sys.path.append("C:\\Users\\Administrator\\Desktop\\TheBridge\\Bootcamp-DataScience-2021\\week4_EDA_np_pd_json_apis_regex\\day2_numpy_pandas_II\\ejercicios_panda")
food = pd.read_excel("food_100.xlsx")
food<jupyter_output><empty_output><jupyter_text>Step 3. Run this cell only once, in order to delete the column `Unnamed: 0`<jupyter_code>food.pop("Unnamed: 0")
food<jupyter_output><empty_output><jupyter_text>Step 4. See the first 5 entries<jupyter_code>food.head(5)<jupyter_output><empty_output><jupyter_text>Step 5. What is the number of observations in the dataset?<jupyter_code>len(food.axes[0])<jupyter_output><empty_output><jupyter_text>Step 6. What is the number of columns in the dataset?<jupyter_code>len(food.axes[1])<jupyter_output><empty_output><jupyter_text>Step 7. Print the name of all the columns.<jupyter_code>food.columns.values<jupyter_output><empty_output><jupyter_text>Step 8. What is the name of 105th column? Position, not index<jupyter_code>food.columns.values[105]<jupyter_output><empty_output><jupyter_text>Step 9. What is the type of the observations of the 105th column?<jupyter_code>food["-fructose_100g"]<jupyter_output><empty_output><jupyter_text>Step 10. How is the dataset indexed?<jupyter_code>food.index<jupyter_output><empty_output><jupyter_text>Step 11. What is the product name of the 19th observation?<jupyter_code>food.iloc[19]<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.11045130641330166, 'fraction_numerical': 0.029097387173396674, 'mean_word_length': 8.683908045977011, 'pattern_counts': {'":': 0, '<': 45, '<?xml version=': 0, '>': 45, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '11', 'dir': 'jupyter-structured-clean-dedup', 'id': '436728', 'license': 'MIT', 'n_tokens_mistral': 665, 'n_tokens_neox': 618, 'n_words': 123, 'path': 'week4_EDA_np_pd_json_apis_regex/day2_numpy_pandas_II/ejercicios_panda/World Food Facts.ipynb', 'repo_name': 'PabloEduardoMartinezPicazo/Bootcamp-DataScience-2021', 'size': '1684'}