Any solution for the guided project on "Working With Data Downloads"

ashleychoy · May 31, 2020, 1:22pm

Hi, can anyone, help me on resolving the below issue?

Compute the sums of all of the columns that break down enrollment by race and gender.

Screen Link:
https://app.dataquest.io/m/220/guided-project%3A-working-with-data-downloads/4/using-pandas-to-explore-enrollment-by-race

My Code:

Replace this line with your code

What I expected to happen:

What actually happened:

Replace this line with the output/error

masterryan.prof · May 31, 2020, 1:39pm

Hi @ashleychoy, could you screenshot the question with your code because I don’t have access to this mission. Thanks!

ashleychoy · May 31, 2020, 1:40pm

@masterryan.prof

here is the mission, but i am stuck on that.

Thanks

masterryan.prof · May 31, 2020, 1:48pm

Hi @ashleychoy could you also screenshot the learn part? I think this is part of the Data Science path which I don’t have access to (I’m under the Dataquest COVID-19 scholarship so I only have access to the Data Analyst path). Also not very sure what they are asking for. Could you also screenshot the data in the csv file?

Perhaps they are asking for you for the individual sum by race and gender so you should have two values, (i.e. race_sum and gender_sum) after using the .sum() dataframe method on the two columns… I’m not too sure about this since I don’t have the context of the question.

ashleychoy · May 31, 2020, 1:57pm

@masterryan.prof, the data file is very large i even cannot load from the screen, but i took the dataframe columns for your reference.

Again, thanks a lot for your help.

Regards,
Ashley

masterryan.prof · May 31, 2020, 2:09pm

Hi @ashleychoy: I think since the statement is not very clear its up to your own interpretation on how you want to do it. I have attached 2 examples of code I came across when looking at the project on Github and both of them seem logical to me although they are two different approaches. I have attached links below:

(Although I think the one in the first link is way more efficient as he made use of one for loop instead of summing up the total for each race 1 by 1)

github.com

sengkchu/dataquest-guided-projects-solutions/blob/master/Guided Project_ Working with Data Downloads/enrollment.py

import pandas as pd
data = pd.read_csv("data/CRDC2013_14.csv", encoding="Latin-1")
data["total_enrollment"] = data["TOT_ENR_M"] + data["TOT_ENR_F"]

all_enrollment = data["total_enrollment"].sum()

columns = [
    "SCH_ENR_HI_M",
    "SCH_ENR_HI_F",
    "SCH_ENR_AM_M",
    "SCH_ENR_AM_F",
    "SCH_ENR_AS_M",
    "SCH_ENR_AS_F",
    "SCH_ENR_HP_M",
    "SCH_ENR_HP_F",
    "SCH_ENR_BL_M",
    "SCH_ENR_BL_F",
    "SCH_ENR_WH_M",
    "SCH_ENR_WH_F",
    "SCH_ENR_TR_M",

This file has been truncated. show original

github.com

ODYTRON/Guided-Project-Working-with-Data-Downloads/blob/master/enrollment.py

# import pandas
import pandas as pd

# code to allow script to run from terminal
if __name__ == "__main__":
    # read csv into dataframe
    data = pd.read_csv("/home/dq/scripts/data/CRDC2013_14.csv", encoding="Latin-1")
    # create a new column that adds the males and females
    data["total_enrollment"] = data["TOT_ENR_M"] + data["TOT_ENR_F"]
    # compute the sum of males and females
    all_enrollment = data["total_enrollment"].sum()
    # compute percentage for males
    total_M = (data["TOT_ENR_M"].sum()/all_enrollment)*100
    # compute percentage for females
    total_F = (data["TOT_ENR_F"].sum()/all_enrollment)*100
    # compute percentage for Hispanic
    total_H = ((data["SCH_ENR_HI_M"].sum() + data["SCH_ENR_HI_F"].sum())/all_enrollment)*100
    # compute percentage for Hispanic
    total_AS = ((data["SCH_ENR_AS_M"].sum() + data["SCH_ENR_AS_F"].sum())/all_enrollment)*100
    # compute percentage for American indian

This file has been truncated. show original

Hope this helps!

ashleychoy · May 31, 2020, 4:33pm

@masterryan.prof, thanks a lot for your help. now i can understand for this.

masterryan.prof · June 1, 2020, 12:28am

@ashleychoy No worries! Anytime!

hshf1992 · June 19, 2021, 9:20am

hi Ashleychoy im trying to open explortaion.py but dont know how my editor in read.py file i would appreciate it if you can help me.

masterryan.prof · June 19, 2021, 11:06am

Hi @hshf1992: may I know which file you are referring to and which editor you use? If it is VSCode or any others with support for Python (i.e. PyCharm etc) and you are trying to view a jupyter notebook file (.ipynb), you will need to install the corresponding jupyter notebook extension. You can also try to install jupyter on miniconda or Anaconda locally.

hshf1992 · June 19, 2021, 11:31am

on the dataquest platform where it says editor next to Terminal below editor where it says read.py i want to be exploration.py .

masterryan.prof · June 19, 2021, 11:36am

@hshf1992: you will have to simply use the terminal to create the file as follows:

cd scripts
ls
touch exploration.py

Kindly revisit the command line missions to recap.

hshf1992 · June 19, 2021, 6:01pm

alright thanks but i tried it didn’t work but when i reload the page it worked because i tried touch and many other command it was let me create it but i couldn’t open or read it but reloading page the Solve the Answer. thanks anyway.