Hi all, in this post, you will learn how to get a text message alert every time your favorite crypto has a price change by creating a surprisingly very easy Python script.

  • Python
  • A Twilio account (to get a number to send a text message from)
  • An AWS ec2-instance (or some other cloud machine)

My latest obsession is Coreto, a relatively new cryptocurrency that aims to disrupt the market by being the “Facebook” of the crypto world. …


Hi everyone! Today we are going to learn how to quickly create a Twitter Bot to troll your friends.

YouTube video

First of all, if you want to practice your Spanish, here is a fun video where I tell you what happened when I trolled my friends with this bot followed by a tutorial. Otherwise, keep reading this post.

In order to be able to follow this blog post, you will need three things:

  1. The most up-to-date Python version (I recommend using Anaconda)
  2. A Twitter developer account. You can get a developer account with your existing Twitter account, but keep in mind…


An overview of AWS's most popular products to deploy machine learning projects with its respective advantages/disadvantages and instructions on how to launch them.

Nowadays, individuals, companies, and governments prefer to use cloud machines over traditional computers for multiple reasons. Among those are the ability to switch machines, upgrade them quickly, obtain bigger RAM, more cores, more GPUs, and perhaps the best reason of all, you pay per second instead of an up-front cost.

Amazon Web Services (AWS) is one of the most popular on-demand cloud computing platforms at the moment. It offers a variety of technical infrastructure products and services…


10 years of tweets and many stories…

👉 👉 👉 YOUTUBE VIDEO: https://youtu.be/m1-MUCQtO3Q 👈👈👈

If you want to see the dynamic plots go here (or if you want to read this in Spanish!)

Hello, my dear cyber-friends! I am still stoked about reaching 1K followers on Twitter 🤗

As I promised it to you on my first YouTube video, here is an analysis of my very own Twitter using Data Science.

If you wish to recreate this project using your own data, all of my code is on Github.

🤔 Where is my data?

To begin this project, the first step is to obtain our…


Well… not just yet!

Last week, during the Spark + AI Summit 2020, Koalas 1.0 was released. Here is the demo in case you are curious.

Koalas is bringing to the data science world the promise of translating the Pandas API into PySpark seamlessly. A dream come true! 🤩 Right?

Pandas is one of the most used tools for data wrangling and analysis, however, it does not scale well when dealing with big data sets. At the moment, when faced with big data, most data scientist have to either migrate to PySpark (which has a significantly different syntax) or sample…


Contrary to how hard is to set up a Redshift driver for Python on an EC2 instance, it is actually quite simple for R.

First, you need to get the driver from AWS with the following command. Make sure you’re in the folder where you want your driver to be.

wget http://s3.amazonaws.com/redshift-downloads/drivers/RedshiftJDBC41-1.1.9.1009.jar

Then, inside R you will run install.packages('RJDBC') to get the package. Depending on how you have your EC2 instance setup, you might need to run this command using sudo R instead of just R for the changes to be preserved after terminating the R session.

3. Connect to…


A step by step ODBC driver setup

My face whenever I have to setup a driver

I don’t know why is it so complicated to configure ODBC drivers in Python nor why there are so many conflicting instructions out there, so I have created this list to help you obtain precious success in this task.

(Disclaimer: This is the way that worked for me, if you know of a better way, please write it on the comments below).

1. Install the requirements

On your EC2 instance, run the following commands:

  • unixODBC: Library that implements the ODBC API on non-Windows operating systems.
sudo yum install unixODBC
  • Redshift driver
# Get the driver
sudo wget https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.13.1000/AmazonRedshiftODBC-64-bit-1.4.13.1000-1.x86_64.rpm
# Install the driver
sudo yum install…


Have you ever seen some really nice custom shapes in a Tableau Public workbook and wished you could use them in your own workbooks? Then you’re in the right place! In this article, you will learn how to “scrape” them using Python.

The workbook we are going to use as an example in this blog can be found here

I was inspired to write this post since the solutions I found online (here and here) didn’t work for me, so I wanted to create something that was an open-source working solution. Nevertheless, I thank them for pointing me in the right direction of the creation of this code.


If you want to see the dynamic plots go here (or if you want to read this in Spanish!)

My loves, today I’ll introduce you to Teresa. She is my best friend since we were 12. When we were little, our moms had to disconnect the landline cable because we would stay up talking until 2 a.m. Nowadays that addiction lives in the WhatsApp world and like the good n̶e̶r̶d̶ data scientist that I am, here I have an analysis of our convos.

🤓 The data


In this post, I will show you how to integrate Python scripts to your Tableau Prep flow. If you’re curious about how to integrate Python to Tableau Desktop, then go to my previous article here.

Tableau Prep ≠ Tableau Desktop

Yes, me too. Until recently, I also was not aware of its existence. So, what is Tableau Prep? It is a data preparation tool allows users to cleanse, aggregate, merge, and do other preparations to their data before it goes to Tableau Desktop for analysis.

Talk Python to me 🐍

That being said, you can also use Python in Tableau Prep to further prepare your data and here I’ll show…

Viviana Márquez

Data Scientist in Miami, FL 🌴 | MSc in DS from the University of San Francisco — BSc in Mathematics from Konrad Lorenz University www.VivianaMarquez.com

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