Author Topic: Lending Club All Notes File Size  (Read 2324 times)

Blake

  • Newbie
  • *
  • Posts: 23
    • View Profile
Lending Club All Notes File Size
« on: October 26, 2012, 12:32:05 AM »
So maybe I just need to update but I like Excel 2003 much better than the newer versions (I hate the new menu bars, but I disgress)

Is there another program any of you use to analyze the file you can download from LC with all their notes?

Or is there a way to download portions of it (I'm not so interested in data pre-2011 for what I'm trying to do).

I don't want to use Lendstats either for what I'm trying to look into.

AnilG

  • Hero Member
  • *****
  • Posts: 1088
    • View Profile
    • PeerCube
Re: Lending Club All Notes File Size
« Reply #1 on: October 26, 2012, 02:26:13 AM »
Google Spreadsheet and Apple Numbers can't handle loanstats file either, not sure about OpenOffice.

LC statistics files are CSV files so you can open them in WordPad and delete the rows you don't want and save them again as plain text file with CSV extension.

If you know scripting/programming you could automatically break the CSV file. I import loanstats CSV file on PeerCube by programmatically breaking the file.

Also, look into Google Fusion Table. It may be able to handle large data set.
---
Anil Gupta
PeerCube Thoughts blog https://www.peercube.com/blog
PeerCube https://www.peercube.com

brycemason

  • Hero Member
  • *****
  • Posts: 801
    • View Profile
    • P2P-Picks.com
    • Email
Re: Lending Club All Notes File Size
« Reply #2 on: October 30, 2012, 10:47:25 PM »
Stata for the win. Any stats package will be able to handle this.

Keltset

  • Full Member
  • ***
  • Posts: 176
    • View Profile
Re: Lending Club All Notes File Size
« Reply #3 on: November 15, 2012, 03:08:56 PM »
I was using python to convert to a sqlite database and running all my calculations in python... I have since switched it to AutoIt and update my sqlite database from there. It's pretty easy to automate the login process to download your notes csv file automatically and parse through your notes as well as download the currently listed notes and historical notes records file with auto it. I set mine up to automatically update every day and i created a little html page that spits out and is set to my browsers home page so when i open my browser I can see if there is anything that needs my attention or if my account has enough money to purchase new notes with I don't have to continually log in to check... I was having to many problems with excel handling the historical notes file on its own... it was just to slow and painful with the massive amount of data. It's easier when you can just pass sql queries to get what you want and not worry about it being updated or not since you can make it auto-update...

AutoIt is a basic windows scripting language, python is more of a real "programmers" scripting language and has more power but I switched to AutoIt because of my own skill level with it far exceeds that of my skill level in python...