Forum

Posted by Eugene, March 5, 2023, 11:42 a.m.

Idea: SQL to Pandas Guide

Hey Leon -

Thought this would be a good future idea - for folks that are coming from Excel/SQL background, it might make sense to showcase how to think in "pandas". Sometimes the operations you do and the order is a bit different, so getting that feel would be pretty good. Not sure the best way to convey it, but maybe some sort of cheat sheet or best practices guide? 

Answers

Hey Eugene,

Love the idea and thank you for the great feedback!

Will start creating a SQL/Pandas similar functions comparison cheatsheet this week.

Have not used Excel for a long time, will see how that will go. : ) From your perspective, do you see many people that were using Excel and are transitioning into Pandas?

 

Thanks again!

Leon

Hey Leon -

I actually think you have a pretty big untapped potential here in a few "markets":

  • Folks that are trying to break into data world (coming from OPs/non-technical background) and are trying to get basics like SQL/Pandas on their resumes
  • Folks that are already analysts in finance (research analysts, associates - not quants), who use Excel all the time but don't know SQL or python

You basically already have all the content built out in forms of questions, you just need to get these folks interested and through the first hurdle (which is "how do I even get started with this?"). Cheat sheet or some sort of walkthrough can help out, and then they can just run through the content and learn by doing. Just my 2 cents. 

Eugene, March 6, 2023, 2:52 p.m.

Gotcha Eugene! Thank you!

It makes total sense, will probably add 1 or 2 guide articles on how to transfer commeon functions/operations in SQL to Pandas,

In addition to that, will add a free tool for code translation.

 

Cheers,

Leon

Leon, March 7, 2023, 9:12 a.m.
SQLPad user avatar

Leon (949)

March 6, 2023, 2:06 p.m.