This playground contains the template to submit your challenge for the position of Project Author for DataWars. In particular, for our Data Analysis with Pandas.

Descriptions of the challenge

You have to develop a sample project following DataWars style. You don't have to worry about autograded activities, just make sure you create an interesting and appealing project including the activities you consider relevant.

In this case, you're tasked with creating a project that helps a student practice Pandas for Data Analysis, covering the following skills:

• Basics of Pandas: DataFrame selection and filtering, sorting etc
• Data Cleaning with Pandas: finding/imputing null values, duplicate values and invalid values
• Pandas string handling (the .str accessor)
• Data Analysis with Pandas: groupping and Q/A and analysis
• Simple visualizations using matplotlib.

Format of the project

The activities must follow this format:

##### 1. Activty Number
Description of the activity with details.

[ Placeholder cell]
Solution:
[ Solution cells]
Tests:
[What tests you'd run to verify the student has performed the activity correctly]

It is recommended you break the project in sections that align with the objectives of this challenge.

Check this example:

The Dataset

You MUST use the dataset associated to this playground for the challenge. The dataset contains answers to the 2021 FreeCodeCamp survey.

You can do whatever you want with the activities, it's up to you.

import pandas as pd

df = pd.read_csv('/data/2021-New-Coder-Survey-csv/2021_New_Coder_Survey.csv')

/tmp/ipykernel_17/1397107983.py:1: DtypeWarning: Columns (8,9) have mixed types. Specify dtype option on import or set low_memory=False.
  df = pd.read_csv('/data/2021-New-Coder-Survey-csv/2021_New_Coder_Survey.csv')

df.head()

	Timestamp	1. What is your biggest reason for learning to code?	2. What methods have you used to learn about coding? Please select all that apply.	3. Which online learning resources have you found helpful? Please select all that apply.	4. If you have attended in-person coding-related events before, which ones have you found helpful? Please select all that apply.	5. If you have listened to coding-related podcasts before, which ones have you found helpful? Please select all that apply.	6. If you have watched coding-related YouTube videos before, which channels have you found helpful? Please select all that apply.	7. About how many hours do you spend learning each week?	8. About how many months have you been programming?	9. Aside from university tuition, about how much money have you spent on learning to code so far (in US Dollars)?	...	45. Please tell us how satisfied you are with each of these following aspects of your present job [Job security]	45. Please tell us how satisfied you are with each of these following aspects of your present job [Work-life balance]	45. Please tell us how satisfied you are with each of these following aspects of your present job [Professional growth or leadership opportunities]	45. Please tell us how satisfied you are with each of these following aspects of your present job [Workplace/company culture]	45. Please tell us how satisfied you are with each of these following aspects of your present job [Diverse and inclusive work environment]	45. Please tell us how satisfied you are with each of these following aspects of your present job [Weekly workload]	46. About how many minutes does it take you to get to work each day?	47. Have you served in your country's military before?	48. Do you currently receive disability benefits from your government?	49. Do you have high speed internet at your home?
0	7/1/2021 10:10:23	To succeed in current career	Online resources, Books, In-person bootcamps, ...	freeCodeCamp, Mozilla Developer Network (MDN),...	conferences, workshops, Meetup.com events	The Changelog	CS Dojo, freeCodeCamp	4.0	120	NaN	...	Somewhat satisfied	Somewhat dissatisfied	I do not know	Somewhat satisfied	Somewhat satisfied	Very dissatisfied	I work from home	No	No	Yes
1	7/1/2021 10:31:01	To change careers	Online resources, Books, Online bootcamps	freeCodeCamp, Mozilla Developer Network (MDN),...	I haven't attended any in-person coding-relate...	The Changelog, Code Newbie Podcast	Adrian Twarog, Code with Ania Kubów, Coder Cod...	10.0	6	30	...	Very dissatisfied	Somewhat satisfied	Somewhat dissatisfied	Somewhat dissatisfied	Somewhat satisfied	Somewhat satisfied	15 to 29 minutes	No	Yes	Yes
2	7/1/2021 10:42:31	To change careers	Online resources, Books, Hackathons, Meetup.co...	freeCodeCamp, Mozilla Developer Network (MDN),...	Meetup.com events	I haven't listened to any podcasts	AmigosCode, Dev Ed, freeCodeCamp, Kevin Powell...	30.0	48	300	...	Not Applicable	Not Applicable	Not Applicable	Not Applicable	Not Applicable	Not Applicable	I am not working	No	No	Yes
3	7/1/2021 11:06:43	As a hobby	Online resources, Books	freeCodeCamp, Mozilla Developer Network (MDN),...	I haven't attended any in-person coding-relate...	Darknet Diaries, Real Python Podcast	freeCodeCamp, Traversy Media	NaN	36	0	...	NaN	NaN	NaN	NaN	NaN	NaN	I am not working	No	No	No
4	7/1/2021 11:14:31	To start your first career	Online resources, Books, Online bootcamps	freeCodeCamp, Stack Overflow, Coursera, Udemy	I haven't attended any in-person coding-relate...	Talk Python to Me	freeCodeCamp, The Net Ninja, Traversy Media	2.0	24	5000	...	Somewhat dissatisfied	Somewhat satisfied	Somewhat dissatisfied	Somewhat satisfied	Somewhat dissatisfied	Somewhat dissatisfied	45 to 60 minutes	No	No	Yes

5 rows × 63 columns