id
type
5 (blog/news article)
status
21 (imported old-v2, waiting for another import)
review version
0
cleanup version
0
pending deletion
0 (-)
created at
2025-11-18 01:47:26
updated at
2025-11-18 01:47:28
url
https://gregreda.com/2013/01/23/translating-sql-to-pandas-part1/
url length
64
url crc
33305
url crc32
103252505
location type
1 (url matches target location, page_location is empty)
canonical status
2 (missing canonical tag in html)
canonical page id
-
domain id
domain tld
2211
domain parts
0
originating warc id
-
originating url
https://data.commoncrawl.org/crawl-data/CC-MAIN-2025-33/segments/1754151279968.16/warc/CC-MAIN-20250807151203-20250807181203-00460.warc.gz
source type
11 (CommonCrawl)
server ip
Publication date
2025-08-07 16:50:42
Fetch attempts
0
Original html size
21383
Normalized and saved size
21383
title
Translating SQL to Pandas, Part 1
excerpt
content
I wrote a three part pandas tutorial for SQL users that you can find here. UPDATE: If you're interested in learning pandas from a SQL perspective and would prefer to watch a video, you can find video of my 2014 PyData NYC talk here. For some reason, I've always found SQL to a much more intuitive tool for exploring a tabular dataset than I have other languages (namely R and Python). If you know SQL well, you can do a whole lot with it, and since data is often in a relational database anyway, it usually makes sense to stick with it. I find that my workflow often includes writing a lot of queries in SQL (using Sequel Pro) to get the data the way I want it, reading it into R (with RStudio), and then maybe a bit more exploration, modeling, and visualization (with ggplot2). Not too long ago though, I came across Wes McKinney's pandas package and my interest was immediately piqued. Pandas adds a bunch of functionality to Python, but most importantly, it allows for a DataFrame data stru...
author
Greg Reda
updated
1764194099
block type
0
extracted fields
109
extracted bits
featured image
article author
title
full content
content was extracted heuristically
detected location
0
detected language
1 (English)
category id
Pozostałe (16)
index version
2025123101
paywall score
0
spam phrases
0
text nonlatin
0
text cyrillic
0
text characters
4433
text words
1023
text unique words
379
text lines
1
text sentences
29
text paragraphs
1
text words per sentence
35
text matched phrases
0
text matched dictionaries
0
links self subdomains
0
links other subdomains
6
links other domains
10
links spam adult
0
links spam random
0
links spam expired
0
links ext activities
0
links ext ecommerce
0
links ext finance
0
links ext crypto
0
links ext booking
0
links ext news
0
links ext leaks
0
links ext ugc
1
links ext klim
0
links ext generic
0
image author
featured image