Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Data Science Case Analysis

10/09/2020 Client: tiger Deadline: 10 Days

Final Case Analysis:


There are several CSV files attached , start with the word document to understand the nature of the data and broad expectations for the final case analysis. You are expected to explore and perform exploratory data analysis and the final analysis.


Data Details: You are given six years of lending data (2012 – 2017) in csv format. The data files are relatively larger than what you have used during this course so far. The size of each file is different and depends upon the number of loans the company issued in a year. It can be noted that the file size are relatively larger 2015 onward, which is when the company went public and started lending more loans. Each file has 31 columns (variables) and the description of each column is provided in the DataDictionary.xls file. 


In addition to that, you are also given the states characteristics in a file called states.csv. This file contains demographic information like population size, median income, unemployment rate etc. 


Lastly, you are given a regions file called states_regions.csv that contains larger regions and divisions that each state falls in. For example, New Hampshire is in the Northeast region and New England division. 


There are three sections to this case: Merging and cleaning (15 points), Data Analysis (60 points), Visualization (25 points) totaling 100 points. 


Merging and Cleaning 


Stack all six Lending Club files together on top of each other. Now join the states.csv file with the stacked file using state name as the primary key. Finally, merge the state_regions file with the combined file so that you have one large file containing lending club and states geographic and demographic information. 


Analysis 


Use the above file to analyze and answer the following questions:


1) Find the distribution of number of loans by state, regions and divisions. Describe in your own words the geographic differences in the number of loans. Also, analyze your results by comparing number of loans per capita. Did you notice any missing states in the Lending Club data? If yes, then find out why. 


2) Compare the average amount of loans granted by all states and divisions. Which states and divisions have the highest and lowest average loan amounts?


3) Compare the average interest rate charged and average loan amount by the loan Grade. Do you notice any patterns? 


4) Run a frequency distribution of number of loans, average loan amount and average interest rate for each state by year (2012 through 2017). Describe the changing patterns in those numbers. 


5) Is there a relationship with the population size of a state and the average loan amount given? Is there a relationship between Grade of loans and median income level in a state?


6) This is an open-ended question where you are asked to share an interesting fact that you found through data analysis. 1) 


Visualization


1) Create a plot of interest rates and Grade or a loan and describe the pattern. 


2) Create a map of US states and color code the map with the average amount of loans given. 


3) Show visually the relationship between the annual income of the recipient and the loan amount obtained from Lending Club


4) Create a plot that shows the relationship between the length of employment and amount of loan obtained. 


5) Create a “regional” map and show an interesting relationship of your liking. 

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Academic Master
Professional Accountant
Homework Guru
Study Master
Top Grade Tutor
Homework Tutor
Writer Writer Name Offer Chat
Academic Master

ONLINE

Academic Master

I have super grip on essays, case studies, reports and discussion posts. I am working on this forum from last 6 years with full amount of satisfaction of my clients.

$30 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

Hi! It is good to see your project and being a reputed & highest rated freelance writer on this website, you can be assured of quality work! I am here to provide you with completely non-plagiarised work

$45 Chat With Writer
Homework Guru

ONLINE

Homework Guru

I am a Ph.D. writer with more than 9 years of working experience in Writing. I have successfully completed more than 4500 projects for my clients with their full amount of satisfaction. I will provide you super quality work according to your given requirements and deadline with ZERO plagiarism.

$30 Chat With Writer
Study Master

ONLINE

Study Master

I am highly qualified expert, working from 2008-9 in this industry. I have all relevant skills and expertise related to your project.

$25 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

I am highly qualified expert, working from 2008-9 in this industry. I have all relevant skills and expertise related to your project. To ensure my potential must visit my profile to check my ratings and uploaded samples. Thanks :--)

$30 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

Hello client, I have gone through the project specifications you have provided and I can easily manage the task. I am an experienced writer with diverse Knowledge in Article writing and Rewriting, Dissertations & Thesis writing, reports, case studies, and Literature Review.

$25 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Paper - 1932 stutz dv 32 ralston victoria - Chase meadow health centre - 10 habits of highly effective people - Environmental sciences - Political Science - Writing economic Essay - Two sinusoidal waves with the same amplitude - Inuit in a 1922 film crossword - Can you use zappos gift card on 6pm - Magnesium and hydrochloric acid experiment method - Pololu rc switch with small low side mosfet - Nola pender model - Theo chocolate strategy formulation and execution - Health Information Management System Week 2 Project - Enrique carrillo herbalife net worth - Target costing case study tata nano - Selected information about income statement accounts for the reed company - Obai sparta - Geopolitical community nursing - Dcid bn pin code - ASSIGNMENT 10/31 - Happy birthday dance song - Intercultural communication paper assignment - Revive health and hydration dothan al - CSIA 485 Discussion - Calculate the molecular mass - Valve and injection timing for a diesel engine - Discussion 08/19 - Discussion: Professional Nursing and State-Level Regulations,NURS 6050 Policy and Advocacy for Improving Population Health - Dolce hayes mansion bed bugs - C++ driver's license exam program - Bacterial and fungal amylase lab report - Kaitlyn's ice cream shoppe financial projection - Intrinsic viscosity of polyvinyl alcohol - Are you looking for someone to complete your MBA dissertation writing ? - Why is it important to listen to your teacher essay - High scope conflict resolution poster - Types of ratios with formulas - Lección 2 repaso pruebas de práctica - Iec 60034 6 method of cooling - Sankey diagram for a hair dryer - Tell city furniture catalog - Advanced construction 401 - You got hired as an IT security manager at the Sunshine Hotel and you have been asked by the general manager to conduct a presentation about data privacy to the executive committee. Create 5-7 PowerPoint slides - Jac and jack glasses - Anthropology Discussion post - What is the plural possessive form of woman - Data domain file system cleaning - Http www woodlands junior kent sch uk homework britain html - 10 minute micro teach ideas - Spotted marsh frog call - Psychology - A right circular cone and a right circular cylinder - An overstatement of ending inventory in one period results in - Bank of baroda power of attorney format - Osha ppe toolbox talk - Eycc msu - Examine a Potential Culture of Innovation to Promote an Entrepreneurial Spirit - Construction of helmholtz coils - Turnigy 9x aux channels - After the deluge lachapelle - Where should pesticides be stored servsafe - Limits of accuracy meaning - Master your money ron blue pdf - King edward medical college punjab university - Are moon jellyfish considered plankton nekton or benthos - Aquafresh white trays - Chapter 1 the woodworking industry answer key - Health and human development unit 4 outcome 1 - Rust oleum specialty stainless steel paint - Haydn enjoyed phenomenal musical success with two trips to - Target market for vacuum cleaners - Just for feet inc - Unit 42 spreadsheet modelling p9 - Burberry sap implementation - Deakin college trimester dates - The prime factorization of 68 - Deliver wow through service zappos - Marketing communication/ branding - Blue ring octopus facts - What is naturalistic observation in psychology - Labor relations and collective bargaining case study - Q3 - Vignette examples in literature - Vicroads road design guidelines - Arrange the following in order of decreasing acidity - Aspirin + naoh equation - Capgemini em foundation certification questions - 99 georgiana terrace gosford - 11029 - LAW - Herron blue side effects - Identify named emergency personnel - Fight for liberty jose orozco - How does the volume occupied by a cubic centimeter - Internet of Things (IoT) - HRM 652 EVALUATING RESULTS AND BENEFITS - States of matter diagram - 2 questions