I need help getting answers for SQL in the PDF file attached. It appears someone posted this assignment already on Homework Market, but I was not able to get the answers. Please help. i need by next Monday September 7, 2020.
page 234-238
1 page apa format
Twitter Data Analysis
NF 160 Introduction to Data Science
Twitter Data Analysis
Due Date: Nov 5, 2020
Points: 22
Objective:
Examine students’ ability to create Twitter applications in order to download tweets by using the R platform for data science projects.
Tasks:
Students will create a Twitter application for scraping tweets by using the R platform. They will use this application to download a total of 200 tweets by searching with their chosen hashtag and from a user profile. The first 100 tweets will be collected by using a student-chosen hashtag/keyword and the rest 100 tweets will be collected from a student-chosen Twitter user profile.
Deliverables:
Two files:
- One word processing/PDF file explaining the steps of Twitter application creation
- The RStudio file that contains codes for Twitter data collection
Submission:
Upload both of these files in Canvas Assignment section.
Points and Rubrics:
Word Processing/PDF file:
- The word processing/PDF file explaining the steps of Twitter application creation will get a maximum of 5 points
- Inclusion of comprehensive application creation steps will get a maximum of 5 points
- Inclusion of minimal application creation steps will get a maximum of 3 points
- No explanation of Twitter application creation will get 0 point
RStudio File:
- The RStudio file will get a maximum of 6 points
- 150-199 tweets comprising of a hashtag and user profile will get 5 points
- 50-149 tweets comprising of a hashtag and use profile will get 3 points
- Less than 50 tweets comprising of a hashtag and user profile will get 2 points
- No tweet will get 0 points
Threat Modeling
Need answer in APA format answer without plagiarism
Auditting
Analyze audit procedures for determining compliance with physical access policies for your organization or an organization with which you are familiar.
In 175 words or more discuss how you can internally audit procedures for determining compliance with physical access policies. Why is it important to maintain compliance with physical access policies? Share how you, as an IT manager, would expect to respond if an external auditor found evidence that your organization is out of compliance with its own physical access policies?
FIFA Bribes PPT
Need a PPT of 5 slides on FIFA bribes ethical issue & it’s outcomes along with references.
Business Continuity Planning and Disaster Recovery Planning
Explain why you believe planning is important. Select one of the following businesses: a large bank, a government agency, or a hospital, and explain which systems you feel are mission-critical. Then explain how the loss of these systems would affect the organization.
and
Go online and search for information about companies that have been harmed or bankrupted by a disaster. Choose one such company and create a briefcase study about it. Successful narratives will focus on the manner in which the organization was impacted, including financial losses, losses of sales, or the need for layoffs. Your assignment should be 3 paragraphs in length
Finance & Blockchain
Prepare an 8 page APA style paper using the resources you have read in this course and at least 3 additional peer reviewed resources. Follow the writing requirements for this course. Include an introduction and conclusion in the paper. This paper should address the following questions:
(1) Does Blockchain technology have the potential to cause a shift in financial business practices that many experts are predicting? Explain why or why not. Support your answer with research.
(2) Is there evidence to suggest that Blockchain technology will change the way finance is applied and practiced? If there is, discuss that evidence. If there is not, what issues exist that impede its adoption?
(3) Which functions of financial management could be most impacted by Blockchain technology? How might the financial functions change? Support your answer with research.
Course writing requirements:
References must be cited within your paper in APA format. Your reference page and in-text citations must match 100%. Papers without in-text citations will earn failing grades.
Always include a cover page and reference page with all submissions (even initial discussion posts)
Provide the exact web link on the reference page citations for all online sources – do not provide just the home page, but the exact link – I check all sources
No abbreviations, no contractions – write formally
Write in the third person formal voice (no first or second person pronouns)
Write more than the minimum requirement of the word count assigned
As always, the word count is only for the body of the paper – the cover page, reference page, and / or Appendix (if included) do not count towards the word count for the paper
Indent the first line of each new paragraph five spaces
Refer to the example APA paper in the getting started folder under the content tab if you need an example. Also, a Power Point is provided under the information tab that addresses APA format.
Use double-spacing / zero point line spacing, a running header, page numbers, and left justify the margins.
Physical Security (Portfolio Project )
You are the new Compliance and Accountability Manager for the mid-size company. During the first two weeks on the job, you have conducted several inspections on the alarm, intrusion, and video technology systems. The findings from your investigations provided overwhelming evidence that these systems are either not operating efficiently, or they are not in compliance with governmental requirements. For this assignment, write a two-page double space memo, the company administrator addressing the following:
- The significance of equipment and system overhaul
- Application and the importance of an effective alarm system and its components
- Getting the systems certified
- An efficient video system
- The lenses and illumination
- Cameras
- Recorders
- monitors
Ideas from the required reading assignment, as well as a biblical integration, must all be integrated into the memo. This memo should be error-free, citations should be presented to support your work, each section must have a sub-header, and your plagiarism score should not be more than 30 percent.
SQLAlchemy- Climate Analysis and Exploration
To begin, use Python and SQLAlchemy to do basic climate analysis and data exploration of your climate database. All of the following analysis should be completed using SQLAlchemy ORM queries, Pandas, and Matplotlib.
- Use the provided starter notebook and hawaii.sqlite files to complete your climate analysis and data exploration.
- Choose a start date and end date for your trip. Make sure that your vacation range is approximately 3-15 days total.
- Use SQLAlchemy
create_engine
to connect to your sqlite database. - Use SQLAlchemy
automap_base()
to reflect your tables into classes and save a reference to those classes calledStation
andMeasurement
.
Precipitation Analysis
- Design a query to retrieve the last 12 months of precipitation data.
- Select only the
date
andprcp
values. - Load the query results into a Pandas DataFrame and set the index to the date column.
- Sort the DataFrame values by
date
. - Plot the results using the DataFrame
plot
method. - Use Pandas to print the summary statistics for the precipitation data.
Station Analysis
- Design a query to calculate the total number of stations.
- Design a query to find the most active stations.
- List the stations and observation counts in descending order.
- Which station has the highest number of observations?
- Hint: You will need to use a function such as
func.min
,func.max
,func.avg
, andfunc.count
in your queries.
- Design a query to retrieve the last 12 months of temperature observation data (TOBS).
- Filter by the station with the highest number of observations.
- Plot the results as a histogram with
bins=12
.