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 4 courses that I strongly recommend to keep exercising after practicing the algorithms in this post:


FORECASTING | PYTHON | OFFICE HOURS

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

Photo by davisuko on Unsplash

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

Introduction

In the first part of this tutorial (Forecasting Business KPIs With Python Using…


Forecasting | Python | Office Hours

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

Photo by Hermes Rivera on Unsplash

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

Introduction

Picture this: you are a data analyst or business intelligence analyst with experience…


Join the data industry, change role or simply learn cutting-edge technologies by enrolling in a Nanodegree!

Photo by Marvin Meyer on Unsplash

A note for my readers: This post includes affiliate links for which I may earn a small commission at no extra cost to you, should you make a purchase.

Use Code SAVE75 to get 75% FLASH SALE on all Udacity Nanodegrees!

You Are Not What You Studied At Uni

As controversial as it may sound, you are not what you studied at university and as you progress with your career, companies will tend to focus less on the classes you attended in your early twenties and more on the skills you acquired along the way and that your will bring to the table once hired.

You are not…


In this hands-on tutorial, learn how to build managed and unmanaged tables with PySpark and how effectively use them in your projects

Photo by Jez Timms on Unsplash

Update: recommended On-Line Courses to learn more about Apache Spark:

Use Code SAVE75 to get 75% FLASH SALE on all Udacity Nanodegrees!

Introduction

Apache Spark is a distributed data processing engine that allows you to create two main types of tables:

  1. Managed (or Internal) Tables: for these tables, Spark manages both the data and the metadata. In particular, data is usually saved in the Spark SQL warehouse directory - that is the default for…


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.

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

Hope you’ll find…


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

Photo by Rachael Gorjestani on Unsplash

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 Jerry Zhang 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.

Photo by Mateo Giraud on Unsplash

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

When To Use A Weighted Average?

Suppose you…

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