Author: Patrik Drhlik

Patrik is a freelance data scientist from Liberec, Czech Republic. He’s doing his PhD at the Technical University of Liberec, where he also teaches software engineering courses. He is highly passionate about the R programming language and data in general. He never leaves home without his Rubik’s cube and loves hitchhiking, athletics, mountains, kangaroos, and beer.

Using the Power of the R Language to Query an SQL Database

Using the Power of the R Language to Query
How do you visualize the results of an SQL query? You usually need to use multiple tools to achieve that. Why not use a tool that communicates with SQL directly and can perform any data analysis task? R is a data-oriented programming language that uses packages (libraries) to help you with nearly every imaginable data analysis task and more. Some of these packages allow R connect to an SQL database so you can query it and perform any desired action on the result set.

Going Down to South Park, Part 3: TF-IDF Analysis with R

Do you think it's possible to determine what a text document is about? Read on to see how we can use R to programmatically identify the main topics of several South Park seasons and episodes! In the second article of the series, I showed you how to use R to analyze the differences between South Park characters. I assumed that Eric Cartman is the naughtiest character in the show and tested this hypothesis with real data–check it out to see my conclusion if you haven't already.

Going Down to South Park, Part 2: Text Analysis with R

Who do you think is the naughtiest character in South Park? You’ll know the answer by the end of this article—and I’m sure you’ll be surprised! In the previous article of this series, I showed you how to use R to analyze South Park dialog. We mostly focused on the show overall. This time, I’ll take a closer look at the most famous South Park characters. We’ll see how much they talk and how their sentiments change across the show.

Going Down to South Park, Part 1: Text Analysis with R

Have you ever liked a TV show so much that simply watching it wasn’t enough anymore? Read on to discover how I used R to analyze South Park dialog and ratings! South Parkis an American TV show for adults that’s well known for being very satirical—the series has made fun of nearly every celebrity and isn’t afraid to be provocative. I literally watch the show every day. I also do lots of data analysis in R every day!