Published inSelectFrom·Apr 17, 2022Member-onlyMapping Fracking Wells in Colorado with PostgreSQLUse SQL to Analyze Data and Draw Maps Analysis Plan Requirements: PostgreSQL with PostGIS enabled and pgAdmin4. Load Data into PostgreSQL — Colorado counties boundary shapefile and a shapefile of fracking well locations from FracTracker Data cleaning — specifying SRIDs, creating the geospatial index, and creating a geometry column from latitude and…Sql6 min readSql6 min read
Published inDev Genius·Mar 31, 2022Member-only3 Easy Ways to import a shapefile into a PostgreSQL databaseBefore we begin, you must have an instance of PostgreSQL installed with the PostGIS extension. PGAdmin is a good database administration software that can be installed with PostgreSQL. Download PostgreSQL — https://www.postgresql.org/ Install PostGIS — https://postgis.net/install/ We also need a dataset. In this post, we will use the University of…Postgis3 min readPostgis3 min read
Oct 13, 2021Member-onlyTips from deploying my first Python Google Cloud FunctionSome quirks of Cloud Functions. The python script was a relatively simple ETL job that tested my abilities to architect and debug, but it was a great experience in deploying production code under constraints. The script simply compared two Google Sheets, and updated the target page with new or updated…Python3 min readPython3 min read
Nov 30, 2020Member-onlyMonitor a Honeypot with Azure App InsightsHave you ever wanted to watch foreign malicious actors attack a virtual machine in real time? In this article, we will do just that with a python honeypot and Azure Monitor. First, I need to give a shout-out to the Microsoft docs for setting up Application Insights. …Azure7 min readAzure7 min read
Published inTowards Data Science·Aug 2, 2020Member-onlyData Viz using Python and Tableau: from API call to Hosted DashboardInteractive charts are key to visual storytelling. — Building an infographic often starts while you are first exploring the data. Matplotlib, Seaborn, and ggplot2 are the classic programming charts, while Plotly has also exploded in popularity. But for me, nothing matches the clean professional aesthetic of Tableau. …Python5 min readPython5 min read
Published inTowards Data Science·Jul 30, 2020Member-onlyCOVID-19 Unemployment Brief: State, Race and IndustryCOVID-19 has been the greatest influence on the US labor market since the 2008 financial crisis. — Faced with a fast-spreading disease, a slew of misinformation and unclear guidance from all levels of government, the national economy contracted as businesses temporarily or permanently shut down. …Data Visualization3 min readData Visualization3 min read
Published inTowards Data Science·Apr 11, 2020Member-onlyLinear Regression by HandLinear regression is a data scientist’s most basic and powerful tool. Let’s take a closer look at the Least Squares Line and Correlation Coefficient. — Invention of Linear Regression Linear regression is a form of linear algebra that was allegedly invented by Carl Friedrich Gauss (1777–1855), but was first published in a scientific paper by Adrien-Marie Legendre (1752–1833). Gauss used the least squares method to guess when and where the asteroid Ceres would appear in the night sky (The…Machine Learning6 min readMachine Learning6 min read
Published inThe Startup·Apr 7, 2020Member-onlyThe Academic StackElevate your mind with a modern productivity stack — Your tools are an extension of your mind As such, they should work maximize your retention and help you realize connections and deeper meanings for your area of study. Your computer is a powerful sidekick for your brain, and its greatest strength is its ability to aid a human mind store information. …Productivity6 min readProductivity6 min read
Published inTowards Data Science·Mar 21, 2020Member-onlyDeploy a .NET API to AzureCreate a SQL database and Serve your API in the cloud! — Introduction This article is the fourth in a series dedicated to building a .NET API for the Angular Tour Of Heroes tutorial. So far, we have: Set up our environment. Built a MSSQL Docker container database for local development. Wrote a .NET API for the Angular Tour of Heroes app. You…Dotnet8 min readDotnet8 min read
Published inTowards Data Science·Mar 19, 2020Member-only.NET Core API — Dive into C#Build a back end web server for the Angular Tour of Heroes tutorial — If you have been following along from the Series outline, and have a working database, an Angular Tour of Heroes App, and a generic .NET API, we have now come to the meat of the Series, writing the C# code for our .NET API. To follow along, you can download…Angular9 min readAngular9 min read
