sql – Mathew Analytics

Turning Data Into Awesome With sqldf and pandasql

July 29, 2018March 24, 20201 Comment

Both R and Python possess libraries for using SQL statements to interact with data frames. While both languages have native facilities for manipulating data, the sqldf and pandasql provide a simple and elegant interface for conducting tasks using an intuitive framework that’s widely used by analysts. R and sqldf sqldf(“SELECT COUNT(*) FROM … Continue reading Turning Data Into Awesome With sqldf and pandasql

SQL Cheat Sheet

October 11, 2016March 11, 2017No Comments

I’ve been putting together a basic SQL cheat sheet that could be used as a reference guide. Here are a series of common procedures that should be of use for anyone who uses SQL to extract data. No explanations are provided as they should largely be known to the end user.