Going from doing most of my analytics work in MariaDB/MySQL to Python/Pandas, an... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

beckingz on May 2, 2020 | parent | context | favorite | on: Medium-hard SQL interview questions

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.

WoahNoun on May 2, 2020 [–]

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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact