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

Living stream ministry mp3 - How do electron configurations work - Eso a walk above the clouds candle puzzle - Library chamberlain.edu - Costmart warehouse case answers - All of the following are characteristics of common stock except - It's like pulling teeth case study - Apple subscription accounting - Written off vehicle inspection qld - Macromolecules questions and answers - A carnot heat engine receives heat at 900 k - Do leather gloves leave fingerprints - 5x 7 4x 8 - Highland literacy phonological awareness - Short research paper due Sunday - Check resmed 30 90w power supply - Diplomacy, Tone, and Emphasis in Technical Writing (final) - Goals and objectives worksheet bshs 405 - Individual analyzing published research article - Radio program proposal example - Ogden publications magazines - Hilda martindale educational trust - In a laboratory experiment you wish to determine - Role and Scope Module 7 written Concept Map - 47 danbury crescent girrawheen - Food and nutrition mark wahlqvist pdf - Observations of a chemical change - 3 Minute Research Report - Is college worth the cost essay - 155 lb to kg - Asme b31 11 free download - 7.4 homeostasis and cells - Agency in business law ppt - Camp millowski - Wk 2, HCS 457: DR 2 - Eye doctor - Single phase transformer schematic - Hozelock mixer tap connector screwfix - Kite runner quiz chapters 1 9 - Partner k750 fuel mix - Sea company reports the following information regarding its production cost - Dell mini projector m115hd - Accounting principles 13th edition answers - Conversation tree social thinking - What is results leadership - Factorytalk view macro examples - Riot games human resources - No one provokes me with impunity - What role does balance play in daoist teachings - Long term care week 8 - Malware - Bhp graduate program 2021 whirlpool - Lat pulldown prime mover - 2 coments each one 150 words (CITATION AND REFERENCE) BY 9/2 - Oxford phonics world 1 pdf free download - Child bracelet size chart cm - Wave buoy gold coast - A physics student on planet exidor throws a ball - Strengths of the affordable care act - How to get rid of hair casts or pseudonits - Nursing care plan for ineffective tissue perfusion - Obgyn soap note template - Preferred products has issued preferred stock with an - Black ops 4 crowd affinity item - Costco case study answers - Hags rags drop rate - 12 stones 12 tribes - Risk of crime - Elite realty acts as an agent in buying - Mountain breeze supplies air filters - Bsc subjects part 1 - Find the exact value of cot 1 1 - Performance lawn equipment case answers - Lab 2 : Quality and Decision Making - New french extremity movement - How to identify the reducing and oxidizing agent - Argumentative Essay: How important was the Cold War to explaining the foreign relations of EITHER India OR Pakistan OR Afghanistan (choose one)? - 110 akuna ave bangor - How to make movie critique - Radiation pattern of a dipole antenna - Activated charcoal shoppers drug mart canada - I need 1200 words total (3 pages 1.5 spacing) on BASED UPON THE PAPERS AND LECTURES, PLEASE COMPARE BRIEFLY SOCIAL MARKET - Stoichiometry of a precipitation reaction labpaq answers - Http similarminds com cattell 16 factor html - Ormond beach soccer club - Report 3(A) - Dairy milk chocolate tagline - Elements of a script play - Standards focus exploring expository writing arthur miller biography answer key - Swedish and danish mutually intelligible - Direct and inverse variation word problems worksheet with answers - Dmaic examples in restaurants - Boxing day tsunami facts - Scannell Industries manufactures - How to calculate mr - NUR501- REPLY TO FRANTZ - Founding brothers the collaborators - Cash was paid by janer's cleaning service - 200 words - Robert stephens geek squad net worth