You mentioned about using python to do most of your spreadsheet analysis and basic functions like that. You should consider doing youtube tutorials or something, I think a lot of people would find that interesting and helpful. I made a mental note when things slow down to reach out to you about it since most of what I do is more big data oriented and it hadn’t even occurred to me to use it for smaller tasks. Any resources or examples you found helpful?
cory schafer on youtube
1 Like
howd the p2p loans treating you btw?
Thanks Igor, I’ll check it out
Yes I’ve been thinking there is a market for teaching Python to business people. Early on when I’d go to stack overflow and ask a question about how to replicate a complex sumif type calculation, the computer science guys had no idea what I was talking about. But I’ve held off because I’m trying to get better at the computer science side of it (reading a few books on good code design mostly) and I’ve been trying to get up to speed on doing bayesian statistical analysis.
I’d say in general you can get pretty far doing the Pandas tutorial on Dataschool YouTube. I have friends who did that and nothing else and started to replace Excel. After that you still have zero idea about computer science theories (classes, loops, etc) but it’s still more maintainable and scalable than a complex excel spreadsheet.
There is also a guy who has a book called practical business python where he covers random things most people do and how to code them. I think his book may be written in python 2,so the syntax has changed somewhat
I’m more than happy to help. I’ve had several friends start to learn during COVID
Most of the spreadsheet stuff I do is abstracting the calculation to a class or function. So you create an object that represents whatever you’d do in the spreadsheet. For my current job, that may be something like an expected amortization table of a pool loans we originate. So I abstract the ideas of that to where I can create that simulation and outputs. Early on in my code I built a loan amortization in 15 minutes in python but an hour in excel, because in excel it was hard to keep track whether I should refer to the prior cell, current cell, etc for the calculations. That’s when I realized doing this stuff in excel is like writing code only in the debug mode. This talk below helped me tremendously
P2p loans did well, especially the ones I bought after the management scandal. But moved out to more tax efficient investments now that my account is too large for the current tax laws
Nice, I’ll check it out and get back to you later. I’m still scaling up in a new job and finishing a nightmare of a move between cities and juggling the tail end of my data science degree but when some of these things alleviate I’ll absolutely get back to you.
Ahh you didn’t use an ira or Roth for them? If it were me I’d put it in a trad ira since the default rate could be brutal. I recall the higher credit scores had really good risk adjusted returns. Now that it’s a bit older. Was just curious if these crowdfunding sites were still good in the long term. What was the cagr net of defaults? Also what credit score did you focus on.
The cagr was around 9 percent. And always in taxable accounts, which made the tax law stuff very important
Yep icic.
You may be interested
I am very excited to let you all know that I will be doing a free webcast on Tips and Techniques to Move from Excel to Python . Michael Kennedy of Talk Python fame will be hosting it with me and I know this will be a great event.
The webcast will be on September 29 at 11:30AM CDT. I encourage you to submit your questions in advance so I can incorporate them into the content. Just click the “Ask a Question” button and submit your question
Nice, bump this when it’s closer!
hell yea.
I had always pictured you differently for some reason. This is really cool man!
Just to clarify this is you on the podcast right? If so very cool, if not still will check it out.
Ha ha ha it’s not me. I just copied the paragraph from an email sent to me
Thanks for clarifying. Now the image I had of you can remain what it was.
1 Like
Does that image look like lil dicky?
I had to look him up, but not at all. I actually pictured you more along the lines of Bowen Yang.
Haha well it certainly is a good guess for Asian on this board. But I’m a mix of lil dicky and Seth Rogan 
how many asian bros do we have. i was pretty sure everyone on ehre was white. the indians went through a trail of tears in this forum during the culling.