Think To Make

Search This Blog

Employee Relations, week-2 Assignments

on October 05, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

Week-2 Assignments:

Get link
Facebook
X
Pinterest
Email
Other Apps

Python Project for Data Science, Assignments.

Question 1: Use finance to Extract Stock Data Reset the index, save, and display the first five rows of the tesla_data dataframe using the head function. Upload a screenshot of the results and code from the beginning of Question 1 to the results below. Question 2: Use Web scraping to Extract Tesla Revenue Data Display the last five rows of the tesla_revenue dataframe using the tail function. Upload a screenshot of the results. Question 3: Use yfinance to Extract Stock Data Reset the index, save, and display the first five rows of the gme_data dataframe using the head function. Upload a screenshot of the results and code from the beginning of Question 1 to the results below. Question 4: Use Webscraping to Extract GME Revenue Data Display the last five rows of the gme_revenue dataframe using the tail function. Upload a screenshot of the results. Question 5: Plot Tesla Stock Graph Use the make_graph function to graph the Tesla Stock Data, also provide a title for the graph....

Databases and SQL for Data Science with Python, week-6 Assignments.

Exercise 1, Question 1: Write and execute a SQL query to list the school names, community names and average attendance for communities with a hardship index of 98. Take a screenshot showing the SQL query and its results. Upload the JPEG (.jpg) file below for your peers to review Exercise 1, Question 2: Write and execute a SQL query to list all crimes that took place at a school. Include case number, crime type and community name. Take a screenshot showing the SQL query and its results. Upload the JPEG (.jpg) file below for your peers to review Exercise 2, Question 1: Write and execute a SQL statement that returns just the school name and leaders’ icon from the view. Take a screenshot showing the SQL query and its results. Upload the JPEG (.jpg) file below for your peers to review Exercise 3, Question 1: Write the structure of a query to create or replace a stored procedure called UPDATE_LEADERS_SCORE that takes an in_School_ID parameter as an integer and a...

Powered by Blogger

Theme images by nicodemos