Please read: Learning pandas, Chapter 4, "The pandas Series Object" Please go through this tutorial series of IPython notebooks on pandas: https://bitbucket.org/hrojas/learn-pandas Here is the official site for pandas: http://pandas.pydata.org/The question is below:Suppose you have ridden a bicycle from New York City to Key West, Florida. Your bicycle odometer shows the total miles, which you have dutifully logged at the end of each day with paper and pencil. Your first two entries might be 55 and 120, indicating that you rode your bike 55 miles on day 1 and 65 miles on day 2. Your task is to create a pandas Series object that holds the cumulative miles at the end of each day, then use your Python skills to show the total miles that you rode each day. Consider how you should best present this information in a Jupyter notebook. You should save your Jupyter Notebook

Attached is the project instructions and the tables and files used for my website. If you need more materials feel free to ask. This is an individual project with 2 phases, and this is the 2nd phase based on 1st phase. • You will design and implement an online Information system using MySQL, HTML and PHP. • You can refer to the project demo website http://imc.kean.edu/TECH3740/Here is the link to the first part of my project and phase 1 of my project. This is phase 2

The purpose of this assignment is to demonstrate query building skills. For this assignment, you will perform a set of exercises in which you will analyze data and develop corresponding aggregate functions to obtain the required information. You will use Microsoft SQL Server and the content from the AdventureWorks databases, as directed by your instructor, to complete the assignment. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL queries used to explore the database tables, and answer the following questions. Query Scenarios Problem One In your new job, you realize you will be calling up the "HumanResources.Employee" table on a frequent basis to answer questions from your manager. Using what you have learned thus far about stored procedures, create an executable "Employees" dataset that will allow you to quickly reference all records in that dataset. However, note that a stored procedure cannot be used in a SELECT statement after it has been created; it simply allows for a quick command to call up a preset data query you have made. Problem Two While a stored procedure is an effective method to review a static dataset, you realize the requirements for questions posed to you change frequently. Your manager often will request information specific to a given job title. You realize you need to create a function that allows a variable to be changed in your SELECT statement each time you run it. Note: To develop the answer to this problem, set the variable to "Design Engineer" and call the Function @JobTitle. Problem Three Your manager wants to build an "Employee Time Off" calendar for the year for easy reference and has asked that you compile a list of vacation hours for each employee under his supervision. This task relates to the one you completed in Problem Two of this assignment, but will require that you restructure the code you developed from Problem Two to build a more complex query in or order to complete the task successfully. As with Problem Two, your manager will request this information often, and on an ongoing basis throughout the year. You realize you need to create a function that allows a variable to be changed in your query statement each time you run it so that you do not need to write new code for every request. The fields you need to bring in are "First and Last Name" and "Sick and Vacation Hours." Note: To develop the answer to this problem, create a join from the person table First and Last Name. Problem Four Your manager would like you to classify employee work areas in the building using a color coding system that he developed. Since no such system exists in the company database, he has asked you to upload his personal Excel worksheet into the database as a new table. Using SQL Server Import and Export Wizard, load the "Roster" tab from the Excel file titled "Color Coding." Write a SELECT statement once loaded to confirm that it loaded correctly. Problem Five Now that your color coding system is in place, your manager wants to know which employees  sit in the "Brown" section, as he will be relocating their desks in the future when the department is expanded. To provide him with this information, use the color coding system you developed for Problem Four, making sure to include the "Color Code," "Job Title," and concatenate "Last Name" "First Name" separated by a comma, calling the field "Full Name."