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

Https www youtube com watch v 7majoi3qmu0 - Case study on retail information system - What challenges did mary mackillop face - A water cycle story - Surface anatomy of heart - Women's lives a psychological exploration 4th edition pdf - American history x dinner - I am a volunteer poem - Miniature ponies for sale nsw - B737 air conditioning system - A person jogs eight complete laps around a 400-m track in a total time of 15.5 min . - 1/2 cup melted coconut oil in grams - 3 p of business communication - Nicomachean ethics book 1 section 7 - Acm code of ethics - St george mobile eftpos machine - Making pronouns and antecedents agree - Atmospheric Science - Gl noble denton uae - List of polyprotic acids - Healthcare program policy evaluation - Www plagiarism org plag_article_citation_styles html - 20 Page Research Paper: APA Style, 12 Point Font, Cite References - Pacific northwest research station - Presented below is information related to farr company - Example of use case diagram for student registration system - Salt of the sea book summary - Marketing - Loss of individuality in the handmaid's tale - Abc v lenah game meats - R class motorcycle licence wa - Yanmar diesel fire fighting pump - Week 2 Discussion -1 Business intelligence - Romeo and juliet quotes about impulsiveness - The winnebago trickster cycle pdf - Snap on torque wrench - 1/9 rouen avenue paradise point - Barbell overhead press athlean x - Access 2016 capstone project ac 2 - Animal farm chapter 6 - M&m chi square lab answers - Business requirements document template - Machine dependent assembler features - Big data means big potential challenges for nurse execs - Allianz global assistance oshc - Te sugiero que primero (tú) (1) (escribir) una lista de las cosas que quieres en un apartamento. - S yard t9 driver review - Graveyard keeper stuck in church - Which of the following varies directly with the interest rate - Jon by george saunders sparknotes - POL 201 American National Government NO PLAGIARISM PLZ Final Paper for Class Thank you!! - Bletchley to kingston milton keynes bus - Informatics and nursing sewell pdf - Features of a newspaper article - Influenza vaccination campaign essay - 730 bus timetable uxbridge to hemel hempstead - We describe charitable donations by corporations to nonprofit organizations as ________. - Wisdom sits in places chapter 4 summary - Kampala international university dar es salaam online application - Psychology unit 4 revision - Margaret atwood happy endings literary analysis - Bolman and deal reframing organizations - Marshall home garden sphere iron gothic trellis - Heterocyclic chemistry exam questions and answers - A pitfall to avoid in pursuing a differentiation strategy is - Valley vet supply 800-468-0059 ks - Leadership Skills - charismatic leadership - Accuracy precision and error practice worksheet answers - Lifemax 60 air hockey table - How to find pka of unknown acid - Business Law - For researcher_d - Teens and technology share a future - Research paper - What does msf stand for in construction - Nursing diagnosis for community assessment - How are electrical wires different from your nerves - Informal and formal deviance - How to calculate summary route - Adp complete payroll and hr plus - 4 discussion - Which of graeter's stakeholders are most affected - Study of the Humanities - Hpe insight remote control online - M&l manufacturing case study solution - Npv crossover rate excel - Pbs nova inside the megastorm - Importance of home economics to individual family and nation - Hillbilly blood spencer net worth - The managerial process of crafting and executing strategy - How to write a script in mla format - Why is nitrogen used in scuba tanks - Economics Class Due Today - Hunger games introduction ppt - After you’ve mulled the assignment and before you rehearse the assignment, you need to - 6 awg current rating - A person should consume more of something when its marginal - Who is narrating the short story charles - Sample sop for digital marketing - Stone keep castles advantages and disadvantages