Your Perfect Assignment is Just a Click Away
We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


Common Business Task in Data Science Project

Common Business Task in Data Science Project

Common Business Task in Data Science Project


Data Assignment 1 will revolve around a common business task in Data Science of taking a large data set and forming some conclusions and answering some research questions your company may have

We will look at a data set I harvested for Washington DC over the last 25 years. You will answer a variety of weather questions based on the data. For each answer you should have corresponding code in python to justify your answer. You may do a python file for each question or do it all in one, it is up to you.

Common to many datasets, some of the data is missing so you will have to determine how to handle missing values.

I have included one file to get you going and to show you a way to handle Dates. The data you will process is weather_data.csv. An example of reading it in is included in

Please answer the following questions:


1) What 3 year period had the highest change in actual mean Temperature?

2) What Month has the highest actual Max Temperature on Average across 25 years?

3) What Month on average had the highest difference between the actual low
and actual high temperature on a given day across all 25 years? (I.e. hard to dress for because
it is cold in the morning/night and hot in the day)

4) What is the actual rainiest month on average?

5) in the last 25 years do we have more days that are above average
precipitation or more days below?

6) Is Washington DC on average getting warmer, colder, or staying the
same over the past 25 years?

a) Has DC’s weather gotten more extreme over the last 25 years? Give
your reasoning, code and proof whether yes or no.

b) What do you think the actual min and the actual max temperature
will be on Thanksgiving 2017 (November 23rd)


Tell me something interesting you found in the data that I might not know


Description of Data


Column Description
date The date of the weather record, formatted YYYY-M-D
actual_mean_temp The measured average temperature for that day
actual_min_temp The measured minimum temperature for that day
actual_max_temp The measured maximum temperature for that day
average_min_temp The average minimum temperature on that day since 1880
average_max_temp The average maximum temperature on that day since 1880
record_min_temp The lowest ever temperature on that day since 1880
record_max_temp The highest ever temperature on that day since 1880
record_min_temp_year The year that the lowest ever temperature occurred
record_max_temp_year The year that the highest ever temperature occurred
actual_precipitation The measured amount of rain or snow for that day
average_precipitation The average amount of rain or snow on that day since 1880
record_precipitation The highest amount of rain or snow on that day since 1880

Turn in your python file and a text file containing your answers to the questions.

We offer the best custom essay writing services at an affordable rate. We have done this assignment before, we can also do it for you.

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Essay Pillars only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Essay Pillars are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Essay Pillars is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Essay Pillars, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.