Publications by Scott Stoltzman
MongoDB and Python – Inserting and Retrieving Data – ETL Part 1
Don’t be intimidated by “NoSQL”For those who are behind the times, the so-called “NoSQL” movement has really gained momentum over the last 5 years (but it has been around much longer than that). The term “NoSQL” is a bit silly, but it conveys the point well enough for those who have lived in the traditional relational SQL world. Whi...
4784 sym Python (1336 sym/8 pcs) 18 img
MongoDB and Python – Avoiding Pitfalls by Using an “ORM” – ETL Part 3
Avoiding MongoDB Pitfalls by Using an ORMIn my previous post, I showed how you can simplify your life by using MongoDB compared to a traditional relational SQL database. To put it simply, it is trivial to provide extra depth in MongoDB (or any document database) by nesting data structures. However, this level of simplicity has its drawbacks, and ...
4209 sym Python (1364 sym/5 pcs) 8 img
MongoDB and Python – Simplifying Your Schema – ETL Part 2
MongoDB vs Relational SQL BenefitsIn my previous post, we created a user object and saved it into a MongoDB collection. This was relatively straightforward but you may see some immediate challenges. While directly inserting data is an acceptable practice, it is similar to writing SQL in the backend of your application. SQL is just fine, but it ma...
2681 sym Python (1418 sym/1 pcs) 10 img
Crime Analysis – Denver-Part 1
Project Background As we all know, Colorado is considered one of the scariest places on earth. Denver, CO has had an enormous influx of people over the last decade and it is still ramping up. So why did I pick Denver? That’s simple, I have lived in Colorado for the majority of my life and want to know more about my capital city. Exploration of...
2519 sym R (1965 sym/6 pcs) 6 img
Crime Analysis – Denver-Part 1
Project Background As we all know, Colorado is considered one of the scariest places on earth. Denver, CO has had an enormous influx of people over the last decade and it is still ramping up. So why did I pick Denver? That’s simple, I have lived in Colorado for the majority of my life and want to know more about my capital city. Exploration of ...
2501 sym R (1965 sym/6 pcs) 6 img
Crime Analysis – Denver-Part 2
Getting More Granular Where we’re going In having noticed the crime rates heading up over the last few years, taking a better look seemed more important. I want to first look at “CRIME” before looking into “TRAFFIC” in the data set. It sounds more interesting and I hope the results don’t keep me up at night. What we’ll do in this...
3711 sym R (3016 sym/5 pcs) 10 img
Crime Analysis – Denver-Part 2
Getting More Granular Where we’re going In having noticed the crime rates heading up over the last few years, taking a better look seemed more important. I want to first look at “CRIME” before looking into “TRAFFIC” in the data set. It sounds more interesting and I hope the results don’t keep me up at night. What we’ll do in this po...
3737 sym R (3016 sym/5 pcs) 10 img
Crime Analysis – Denver-Part 3
Marijuana, Alcohol, and Other Drugs Continuing our Exploration of the Data After identifying the sources of crime growth, it’s time to investigate specific crime rates. This blog post addresses drug and alcohol crimes in Denver over the past few years. This is a very simplistic view because it will only focus on trend data, which never tells...
4941 sym R (4733 sym/7 pcs) 12 img
Crime Analysis – Denver-Part 3
Marijuana, Alcohol, and Other Drugs Continuing our Exploration of the Data After identifying the sources of crime growth, it’s time to investigate specific crime rates. This blog post addresses drug and alcohol crimes in Denver over the past few years. This is a very simplistic view because it will only focus on trend data, which never tells t...
4915 sym R (4720 sym/7 pcs) 12 img
Seinfeld Characters – A Post About Nothing
This post is dedicated to my mother – Seinfeld’s greatest fan. Seinfeld is a classic TV sitcom. It featured four main characters surrounded by relatively normal, everyday, run of the mill scenarios. In the spirit of Seinfeld, this post will also “be about nothing.” Load Required Libraries library(scales) library(RMySQL) ...
4042 sym R (5101 sym/10 pcs) 10 img