Programming | Interviewing | Office Hours

In this article I present and share the solution for a number of basic algorithms that recurrently appear in FAANG interviews

Photo by Headway on Unsplash

Update: Many of you contacted me asking for valuable resources to nail Python coding interviews. Below I share 5 courses that I strongly recommend to keep exercising after practicing the algorithms in this post:

Hope you’ll find them useful too! …


FORECASTING | PYTHON | OFFICE HOURS

Learn how to add value to your business by forecasting future performance with Prophet

Image Created By The Author With Matplotlib

Update: Many of you contacted me asking for valuable resources to learn more about time series forecasting with Python. Below I share 2 courses that I personally took and that would strongly recommend to expand your knowledge on the topic:

Hope you’ll find them useful too! Now enjoy the article :D This post includes affiliate links for which I may make a small commission at no extra cost to you should, you make a purchase.

Introduction

In the first part…


Forecasting | Python | Office Hours

Learn how to add value to your business by forecasting future performance with Prophet.

Image Created By The Author With MatPlotLib

Update: Many of you contacted me asking for valuable resources to learn more about time series forecasting with Python. Below I share 2 courses that I personally took and that would strongly recommend to expand your knowledge on the topic:

Hope you’ll find them useful too! Now enjoy the article :D This post includes affiliate links for which I may make a small commission at no extra cost to you should, you make a purchase.

Introduction

Picture this: you are…


Learn how to replace items in a Python list by solving basic algorithms a get ready for your next coding interview

Photo by Martin Woortman on Unsplash.

Introduction

While preparing for your next Python coding round, you might have noticed that algorithms requiring to manipulate one or more lists appear rather frequently. Sooner or later, you should expect to encounter one of them during your interviews as well.

Algorithms requiring to manipulate one or more lists appear rather frequently. Sooner or later, you should expect to encounter one of them during your interviews as well.

In order to help you in the process of mastering this data structure and improve your coding skills, below I present 4 methods to replace an item in Python lists as well as…


Meet the twins emerging roles in the data industry and learn how to become one of them

Photo by Rawpixel on Freepik

The data and analytics industry is constantly evolving and with it, the the “traditional” roles in data teams. These changes recently gave birth to two new data professionals: the Analytics Engineer and the BI Engineer.

These roles may be considered both twins and hybrids. Twins because, more often than not, they share very similar job descriptions and solve similar problems. Hybrids because in practice they are half data engineers and half data analysts.

These roles may be considered both twins and hybrids.

A previous blog post on the topic claimed that the term “Analytics Engineer” has originally been coined by…


In this tutorial, learn how to build a simple ETL to move Google spreadsheets data across systems with few lines of code

Source: Image By Stories On Freepik

Picture this: you are in the process of gathering data sources to build a new report and realize that some datasets are still updated manually by your stakeholders and stored in Google spreadsheets… sound familiar?

In this case, you have two options: either you run a crash course to teach your less technical colleagues to work with SQL and data warehouses or you automate the process yourself with Python.

In this tutorial, you will learn how to pull datasets from a Google spreadsheet with Python by connecting to the Google Drive API and then store them into a database table…


Learn how to use the csvkit and psql libraries to analyze, transform and move data across systems through the command line

Photo by Natalino D’Amato on Unsplash

Introduction To Csvkit

csvkit is a command line tool built as a Python library, that is optimized to explore, transform, and move comma-separated datasets across systems.

Althought csvkit is often presented as a quick alternative to other programming languages to perform data science tasks, it really unleashes its true potential when used by data engineers that are comfortable working with the command line on a daily basis.

“It’s not uncommon for data engineers to support other teams in the business, transforming manually populated CSV files into static tables located in a database”

For instance, it’s not uncommon for data engineers to support other…


Programming | Interviewing | Office Hours

In this brief tutorial, I show how to compute weighted averages in Python either defining your own functions or using NumPy.

Source: rawpixel.com via freepik.com

Update: Many of you contacted me asking for valuable resources to automate Excel tasks with Python or to apply popular statistical concepts in Python. Below I share four courses that I would recommend:

Hope you’ll find them useful too! Now enjoy the article :D This post includes affiliate links for which I may make a small commission at no extra cost to you should, you make a purchase.

When To Use A Weighted Average?

Suppose you had to…


Programming | Interviewing | Office Hours

Practice by solving SQL exercises taken from real coding interviews and finally get the job you deserve.

Photo by Azharul Islam on Unsplash

Update: Many of you contacted me asking for valuable resources to practice more advanced SQL concepts for coding interviews including real interview questions. Below I share 4 courses that I personally recommend:

Hope you’ll find these useful too! Now enjoy the article :D This post includes affiliate links for which I may make a small commission at no extra cost to you should, you make a purchase.

Stop Underestimating SQL Interviews

While…


Python, Office Hours

Download historical stock prices and combine them into a single dataset using the powerful reduce() function.

Photo by Artem Podrez from Pexels

If you just started using Python to analyze historical stock prices with the aim of visualizing trends and build investment strategies, or if you are a more experienced coder tired to use loops, you should stick around and learn how to improve your scripts with the reduce() function.

For instance, let’s suppose you selected a number of stock tickers and your task was to download the historical adjusted close prices for each company and merge them in a unique clean dataset similar to the one below:

AnBento

BI Engineer | FinTech Industry | SQL, Python, Apache Spark | LinkedIn: https://www.linkedin.com/in/anbento4

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store