Data Manipulation with pandas
Run the hidden code cell below to import the data used in this course.
# Import the course packages import pandas as pd import numpy as np import matplotlib.pyplot as plt # Import the four datasets avocado = pd.read_csv("datasets/avocado.csv") homelessness = pd.read_csv("datasets/homelessness.csv") temperatures = pd.read_csv("datasets/temperatures.csv") walmart = pd.read_csv("datasets/walmart.csv") print(avocado)
Add notes about the concepts you've learned and code cells with code you want to keep.
Add your notes here
# Add your code snippets here # Taking notes that how 2d array work so
Use the DataFrames imported in the first cell to explore the data and practice your skills!
- Print the highest weekly sales for each
walmartDataFrame. Limit your results to the top five departments, in descending order. If you're stuck, try reviewing this video.
- What was the total
nb_soldof organic avocados in 2017 in the
avocadoDataFrame? If you're stuck, try reviewing this video.
- Create a bar plot of the total number of homeless people by region in the
homelessnessDataFrame. Order the bars in descending order. Bonus: create a horizontal bar chart. If you're stuck, try reviewing this video.
- Create a line plot with two lines representing the temperatures in Toronto and Rome. Make sure to properly label your plot. Bonus: add a legend for the two lines. If you're stuck, try reviewing this video.
Taking notes how 2d array work cause dataframe are 2d array every data structure is built using array