"Clarify
can we limit traffic to normal commute time for people going to work in their city? Not include business travel? (Recognize traffic can mean: pick up drop off kids; errands, grocery, shopping, social, people who drive for their job etc.)
limit to US?
pre-covid time?
Equation
\# of working people in US x # of hours commute per year per person
\# of working people in US
320M total population, 40M per age group of 10 years
working age = 20 to 70, 5 groups of 1"
Anonymous Cricket - "Clarify
can we limit traffic to normal commute time for people going to work in their city? Not include business travel? (Recognize traffic can mean: pick up drop off kids; errands, grocery, shopping, social, people who drive for their job etc.)
limit to US?
pre-covid time?
Equation
\# of working people in US x # of hours commute per year per person
\# of working people in US
320M total population, 40M per age group of 10 years
working age = 20 to 70, 5 groups of 1"See full answer
"The solution produces the same result as the 'prescribed solution' yet it does not get accepted In the test results section
transcript['year'] = transcript['year'].astype(str)
df = pd.pivottable(data = transcript, index = 'studentid', columns = 'year', values = 'yearlygpa', aggfunc = 'mean').resetindex()
df = df[(df['2021'] < df['2022']) & (df['2022'] < df['2023'])]
df['average_gpa'] = df[['2021', '2022', '2023']].mean(axis=1).round(2)
return df
"
Prachi G. - "The solution produces the same result as the 'prescribed solution' yet it does not get accepted In the test results section
transcript['year'] = transcript['year'].astype(str)
df = pd.pivottable(data = transcript, index = 'studentid', columns = 'year', values = 'yearlygpa', aggfunc = 'mean').resetindex()
df = df[(df['2021'] < df['2022']) & (df['2022'] < df['2023'])]
df['average_gpa'] = df[['2021', '2022', '2023']].mean(axis=1).round(2)
return df
"See full answer
"Target Consumers:
corporate clients - for business meetings
students (in school, college)
aspirants who want to take competitive exams/tests
Identify underserved customer needs:
re-application leads to post-it's not being sticky enough
space crunch so user needs to be precise
post-its need to stick from all 4 corners for it to be readable and so it folds less
writing with pen, marker gets imprinted on next page
Define Value Proposition: a small piece of paper with concise list of"
Priyanka D. - "Target Consumers:
corporate clients - for business meetings
students (in school, college)
aspirants who want to take competitive exams/tests
Identify underserved customer needs:
re-application leads to post-it's not being sticky enough
space crunch so user needs to be precise
post-its need to stick from all 4 corners for it to be readable and so it folds less
writing with pen, marker gets imprinted on next page
Define Value Proposition: a small piece of paper with concise list of"See full answer
"The question is incomplete --- the code only passes if you return the data frame sorted by BOTH department name AND rank. While in the problem description, it mentions to only rank by department name: "The results should be ordered by department name."
Not a big difference I know, but students shouldn't need to look into the solution to get the necessary knowledge to answer the question."
Chao peter Y. - "The question is incomplete --- the code only passes if you return the data frame sorted by BOTH department name AND rank. While in the problem description, it mentions to only rank by department name: "The results should be ordered by department name."
Not a big difference I know, but students shouldn't need to look into the solution to get the necessary knowledge to answer the question."See full answer