import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
import seaborn as sns

pandas basics¶

california_cities.csv contains the population and area in km2 for california cities

URL = "http://www-sop.inria.fr/members/Arnaud.Legout/formationPython/Exos/california_cities.csv"

# we extract only 3 columns
cities = pd.read_csv(URL)[["city", "area_total_km2", "population_total"]]

Explore the dataset with `info()` and `describe()`¶

# your code

How many cities with the 25% largest population ?¶

# your code

Get the name of the cites with the 25% largest area¶

# your code

What is the area and population of Berkeley?¶

# your code

Which cities have between 110k and 120k inhabitants?¶

# your code

pandas basics

pandas basics¶

Explore the dataset with info() and describe()¶

How many cities with the 25% largest population ?¶

Get the name of the cites with the 25% largest area¶

What is the area and population of Berkeley?¶

Which cities have between 110k and 120k inhabitants?¶

Explore the dataset with `info()` and `describe()`¶