3 ms·
These things are impressive. It is funny that sometimes to do crazy Excel acrobatics to solve what would be a few lines of code in Python or other approaches.
by JCM9 2y ago
These things are impressive. It is funny that sometimes to do crazy Excel acrobatics to solve what would be a few lines of code in Python or other approaches.
- listenallyall 2y agoStep 1. Open Excel Step 2. Start building your model. Or... Step 1. Open VSCode or PyCharm Step 2. Front-end... hmmm, web? Electron? Qt? Jupyter? Step 3. venv Step 4. pip Step 5. SqlAlchemy? Psycopg? Raw SQL? Import CSV? Step 6. "Where we gonna host this? Local? Cloud? Serverless? Do we need Docker? K8s?" Step 7. git init Step 8. "Hey, do any of you know what these mean on the specs? IRR? COGS? NPV? I studied CompSci, not this lame finance bullshit" Step 9. Call up Fred from Accounting for some help. Step 10. Fred starts with Step 1, above.
- hatthew 2y agoIf we're building straw men I'll contribute Step 1. Open Colab. Step 2. Start building your model.
- TeMPOraL 2y agoStep 3. Ponder the necessity of having a computer more powerful than a potato when you're going to do the work in the cloud anyway, while you wait for the Internet connection to come back. Step 4. Build your model. Step 5. Take a break to watch silly cat videos. Step 6. Lose your model, and all models you previously made, as Google banned your account, and all associated accounts, for the crime of using emojis in a YouTube comment.
- wildzzz 2y agoOpen notepad++, start writing your code, run it in a terminal.
- hiccuphippo 2y agoMy one excel trick is to copy the data to the clipboard then use xclip/pbpaste, pipe it to sort, uniq, sed, etc then back to xclip/pbcopy and paste back to excel.