Data Analysis Project using SQLWORKBENCH - NEED ASAP
$30-250 USD
Igangværende
Slået op cirka 6 år siden
$30-250 USD
Betales ved levering
MUST USE SQL WORKBENCH.
Write a code to join the two tables on the year and state fields into one SQL table that identifies the absolute differences (in whole rounded hundreds) in the estimates of 10,000 individuals or more between the two datasets. If the earlier estimates are larger than 10,000, the cells should indicate a negative value. Provide a screenshot of your tested code showing successful execution.
Explain how you prepared the data and how the datasets were imported into two SQL tables. Provide a screenshot of the successfully executed SQL code.
Export the data from the SQL table into a CSV file, with rows representing the states and columns representing the years that both datasets estimate, that only shows the differences between the datasets (in whole rounded tens of thousands) that exceed 10,000 individuals.
Note:
In your output CSV file include the name of the state, the year, and the delta value, rounded delta in tens of thousands, e.g., i. If the delta is 10,253, for example, the rounded delta would be 10,000.
Make sure you calculate the differences for all the common years, i.e. years for which estimates are present in both files (i.e. for all years in the period 2010-2015). Always remember that you work with two data sets.
Must show all work.
Hi there,I am Miljan,Data Analysis expert from Bosnia & Herzegovina,Europe.
I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline.
Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me.
Please feel free to contact me so that we can discuss further details.
Thank you for taking the time to read my proposal.I am looking forward to hearing from you.
Kind regards
Hello, I read your whole proposal, and thanks for your post on my good experience.
This is very good job for me.
So I think I can do this in high quality.
My releavant skills are: Data Analytics, Python, R Programming Language, SQL, Web Scraping
I want to further discuss with you.
I look forward to working together in partnership on your project and into the future.
Best Regards.
Hi,
This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology.
I have worked in many data analytics projects involving SAS, Python, SQL & R. Also I have worked in projects involving Excel (Pivot Table, Macros) and VBA.
I believe I have enough expertise in SQL to complete this project as per your requirement. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you.
Thanks & Regards,
Santhosh