Python,R

M2 assign 1

1. Show the variation of goals (sum and average)  with respect to funding status as shown in the lecture video.

2. Show the variation of number of donors (sum and average) with respect to funding status as shown in lecture video. Also include school state as filter.

3. Create a dashboard including above charts.

Submit one document with screenshots of each of the above visualizations. Also, submit your Tableau file.

M3 assign 1

1. Create a pandas data-frame with columns: (1) Project_ID; (2) School_city; (3) Goal; (4) num_donors. (2 points)

2. Show mean values of Goal and num_donors for each school_city using groupby() function. (2 points)

3. Present descriptive statistics for the data-frame. using describe() function. (2 points)

4. Create another data-frame from Crowdfunding_data_1000_projects.xlsx with columns: (1) Project_ID ; (2) school_state, and merge with data-frame from step (1). (2 points)

5. Using the merged data-frame from step (4), select rows where school_state is MO and num_donors>1. (2 points)

Upload one Jupyter Notebook file in submission.