Mapping Chicago Rideshare Data


Earlier this month, the City of Chicago became the first major American city to make rideshare data public. Following a number of recent controversies over user anonymity and privacy in publicly-released location data, the City performed an extensive amount of data de-identification before making the datasets public.

With datasets for trips, drivers, and vehicles all available, I thought it would be fun to play around and see what we might be able to find in the data! Note that only the months of November and December, 2018 are in the scope of this data, so all activity below is reflective of those two months.

Read More

Analyzing the Mueller Report with Python, R, and NLP APIs


The Special Counsel’s Investigation into Russian interference in the 2016 United States election, better known as the Mueller Report, has been one of the more fascinating stories of our time. Responsible for a number of indictments and convictions of political operatives related to the President and the Trump campaign, the Report ultimately did not conclude that the President committed obstruction of justice beyond a reasonable doubt. It did, however, indicate that it could not clear the President of those allegations either - leaving the truth-seeking portion of the US public in a tough spot.

Read More

Visualizing Uber's S-1 IPO Filing


Following their rival Lyft’s recent public offering, Uber’s much awaited IPO seems to be finally coming to pass. On Thursday, Uber filed their S-1 with the Securities and Exchange Commission (SEC), which outlines the details of their current operations, financial health, and planned use of offering funds. While a variety of other outlets have reported extensively on some of the details in the filing (such as the fun fact that a quarter of Uber’s revenue comes from only five cities), I thought it might be handy to build a few charts to more easily visualize some of the financial metrics being reported.

Read More

NBA Season Retrospective (2018-2019)


With the NBA regular season concluded and the playoffs now on deck, I thought it would be fun to peek back at the players and teams that defined this season. There’s a million things one could investigate, but I wanted to call out just a few of my findings that really resonated in combination with what I observed watching games this season!

MVP Candidates

MVP Candidates - NBA 2019

It’s commonly accepted that there is an inverse relationship between efficiency and utilization - as a player bears more offensive responsibility, their scoring typically becomes less effective on a marginal basis. Consider a player like Steven Adams, who is great in his role of taking 7 or 8 shots per game. Do you think Steven Adams would maintain his shooting percentages if forced to take 12, 15, or 18 shots per game? In almost all cases, players typically struggle to retain their shooting efficiency as their offensive workloads increase. This isn’t due in any part to their merits as players, but simply because of the toll that increased decision-making, ball handling, clutch shooting, and offensive creation requires of any player.

Read More

H1-B Visa Analysis


I was recently reading Hacker News and noticed a post linking to the USCIS H1-B data repository, which contains information on the H1-B Visa applications process and statistics about visa submission, approval, and rejection by Citizen and Immigration Services.

As a bit of background, the H1-B visa program was created to allow US employers to employ foreign nationals in jobs requiring specialized knowledge and a bachelor’s or master’s degree. H1-B visas must be sponsored by an employer, and are typically valid for 3 - 6 years. While there is a cap of 65,000 visas that can be awarded each year, there are a number of exemptions for research institutions, particular countries of origin, and rollover between years that make the practical number of visas available much higher. Furthermore, there are 20,000 H1-B visas available to individuals who possess a master’s degree or higher from an American university. This means the total number of H1-B visas available in the lottery is in the 150,000 - 200,000 / year range, for both initial and continuing visas.

Read More

Analyzing MLB Team Payrolls (2019)


MLB Team Payrolls

Given Major League Baseball’s status as the only major American sports league without a salary cap, I’m always interested in seeing how teams choose to allocate their resources every year. There’s a lot that plays into how much any given team will spend on their roster, depending on everything from how badly a team is looking to compete, the proportion of their production coming from young players vs older players, how their local cable TV deals are looking, and how much of a dip each team takes in that season’s free agent market.

Read More

March Madness 2019 Preview


With March Madness right around the corner, I thought it would be fun to visualize a bit of data about each region and team, with the end goal of being a bit better informed for filling out my bracket! The data below is mostly drawn from Ken Pomeroy’s college basketball rankings, and is intended to give a brief overview of the teams and regions in this year’s tournament.

Comparing Regions

NCAA Tournament Regions

Read More

NL East Season Preview (2019)


After writing my recent article about Bryce Harper’s signing with the Phillies, I started getting really excited about the return of baseball! With Spring Training in full swing and most free agents signed and with their teams, we can start to look at how each team projects to perform in the 2019 season. As a big Washington Nationals fan, my attention naturally gravitated to the NL East. Take a look below to see how each team in the division projects to stack up!

Read More

LeBron James Career Scoring


LeBron’s Career Scoring as a Waterfall Chart

Charting LeBron

LeBron James passed Michael Jordan tonight on the NBA’s all time points scored leaderboard, surpassing MJ’s 32,292 career points to vault him into 4th place. While this season has largely been one to forget for the Lakers, LeBron’s pursuit of Kareem Abdul-Jabbar and the possible arrival of Anthony Davis or a second star guarantee that there will be lots of excitement in LA for the next few seasons.

Read More

Santa Monica Homesharing


One of the interesting facts that I’ve learned as I continue to settle down in Santa Monica is that since May of 2015, the City of Santa Monica has effectively banned short-term home/vacation rentals. This decision was made with an eye to AirBnB and other online leasing platforms, and with the intention that Santa Monica’s few apartment buildings not turn into de-facto hotels with new people in and out every weekend. As an alternative, the City has launched a “home-sharing” program which allows homeowners who register to host a visitor in their home for up to 30 days, as long as the resident is also living there concurrently.

Read More