News for hackers. Stuff that matters.

A comment on Medium-hard SQL interview questions. Parent comment

Re:Medium-hard SQL interview questions by beckingz on Saturday May 02, 2020 @06:36PM (#23055437)
Going from doing most of my analytics work in MariaDB/MySQL to Python/Pandas, and R/Dplyr, I'm amazed by how much trickier the syntax and operations are in Pandas.
[ Parent | on HN ]
Re:Medium-hard SQL interview questions by WoahNoun on Saturday May 02, 2020 @07:01PM (#23055563)
Yea, when I do use R, I end up almost always doing the data manipulations in sqldf (creates a sqlite db on the fly).

But I do love doing vectorized operations in pandas/numpy. Writing a quick function then calling it against an entire numpy array is kind of fun.

[ Parent | on HN ]