🥫HOMEWORK 1: Intro to NumPy & Pandas🥫

Questions based on Mini-Lecture 2️⃣

To work on this HW, duplicate this Notebook and edit it in your workspace!

import pandas as pd import numpy as np from datascience import *

Dataset to use: click me!

https://www.kaggle.com/datasets/ulrikthygepedersen/which-ketchup-is-best

🍅 Background info/context: I LOVE Ketchup! (who doesn't?) Unfortunately, there's too many brands out there and in this economy I can't afford to buy every bottle to taste every brand. To help me solve this personal crisis, please take a look at this survey dataset containing a survey of people's opinions on different ketchup brands, their prices, and other information!

1. NumPy #️⃣🥧

# importing dataset as a NUMPY dataframe ketchup_np = Table().read_table("Ketchup.csv") ketchup_np

##Question 1: Sort the prices of heinz ketchup in ketchup_np in ascending order, return top 10 ketchup_np.sort("price.heinz" , descending = False).show(10)

##Question 2: Group by ketchup choice, then show only the ketchup choice and average prices of each brand ketchup_np.group("Ketchup.choice" , np.mean).select(4 , 5 ,6 , 7)

2. Pandas!! 🐼

# QUESTION 5: Within the Ketchup.choice column, select all the people who chose heinz. Then sort in DESCENDING order by price. heinz = ketchup_pd[ketchup_pd["Ketchup.choice"] == 'heinz'] heinz.sort_values('price.heinz' , ascending = False)

Unnamed: 0int64

1 - 4953

Ketchup.hidint64

1 - 1953

1159

1160

430

968

969

355

1610

1611

599

241

242

4884

4885

1893

4435

4436

1691

108

109

3077

3078

1165

4625

4626

1779

578

579

221

3. Reading! 📚

Read this article: click me! Give a 5 sentence summary of the article or something that you've learned from it.

https://medium.com/@dssberkeley/behind-berkeleys-most-popular-double-major-how-applicable-is-ds-x-econ-in-industry-64ea4dcca327

From the article I've learned that Data science and Econ is not only the most popular double major at Cal at 40% but it's also the highest domain emphasis pairing at 17%. It was insightful to see the experiences of the Cal alumni and the process they had to go through to get hired. I also thought it was cool to see the real life application of data science and econ knowledge to help solve business problems. I liked how the alumni also highlighted the need for communication and empathy to proficiently and optimally solve problems. I also learned that I can explore my resources through online news sources that are free from Cal.

🥫HOMEWORK 1: Intro to NumPy & Pandas🥫

Questions based on Mini-Lecture 2️⃣

1. NumPy #️⃣🥧

2. Pandas!! 🐼

3. Reading! 📚

Congrats!! That's it! You've just finished your first HW in the DeCal! 😃