<jupyter_start><jupyter_text>Análise de Dados com Python e Pandas<jupyter_code>import pandas as pd
df = pd.read_csv("datasets/Gapminder.csv", sep = ";", error_bad_lines=False)
df.head()
df.rename(columns={"country":"Pais", "continent":"Continente", "year":"Ano", 
                   "lifeExp":"Expectativa de vida", "pop": "Pop Total", "gdpPercap":"PIB"}, inplace=True)
df.columns
df.shape
df.info()
df.tail()
df.describe()
df["Continente"].unique()
Africa = df.loc[df["Continente"]=="Africa"]
Africa.head()
#A count o número de paises
df.groupby("Continente")["Pais"].count()
df.groupby("Continente")["Pais"].nunique()
df.groupby("Ano")["Expectativa de vida"].agg(['min', 'max'])
df.groupby(["Continente", "Pais"]).agg({"PIB": ['mean']}).reset_index()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.22038216560509555, 'fraction_numerical': 0.0, 'mean_word_length': 6.9393939393939394, 'pattern_counts': {'":': 7, '<': 5, '<?xml version=': 0, '>': 5, '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': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '463756', 'license': 'MIT', 'n_tokens_mistral': 297, 'n_tokens_neox': 296, 'n_words': 50, 'path': 'notebook1.ipynb', 'repo_name': 'dev-JoseAlberto/Analise-dos-Dados', 'size': '785'}