Visualizing WhatsApp Chats using Python and Power BI

Visualizing WhatsApp Chats using Python and Power BI

INTRODUCTION

INTRODUCTION

More than 1 billion people in the world in over 180 countries make use of Whatsapp to stay in touch with friends and family and carry out business and other social interactions. It allows users share messages in the form of text, pictures, videos and voice notes and is thus a great source of data for analysis.

In this tutorial we will go through exporting data from the Whatsapp platform, importing it into Python, transforming and cleaning this data and finally creating an awesome interactive dashboard using Power BI.

PREREQUISITES

Before we get started you’ll need to have the following packages installed in your Python environment:

  1. pandas
  2. matplotlib
  3. regex
  4. Dateparser
  5. numpy

You can easily install these packages by running the pip install command in your Jupyter notebook or on the Command line. You can also use conda install in Jupyter or Anaconda prompt if you are working on an Anaconda distribution of Python. For example, to install pandas you run:

pip install pandas

or

conda install pandas

Once you have all these packages installed we can then delve into Data Collection.

EXTRACTING WHATSAPP CHAT DATA

For this tutorial, I’ll be working with data from Resagratia Whatsapp Group Chat but you can make use of your own data. Simply open the Whatsapp app on your mobile, navigate to the chat you want to analyze (I’ll suggest a group chat for its wide range of visualization options), click on the vertical ellipsis (the three small dots beside the phone symbol), click on More, select Export chat and choose WITHOUT MEDIA. Including media takes ages to export and we don’t want that. Then select the Email option and export.

python power bi visualizing whatsapp

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Tableau vs Power BI: Comparing the Data Visualization Tools

In analytics, Tableau is the leading visualisation tool. Its rich analytical features and attention to data details are the reason behind its popularity. Power BI, on the other hand, is preferred by professionals who are more comfortable with...

Power BI In Brief – 2020

Every month, we bring you news, tips, and expert opinions on Power BI? Do you want to tap into the power of Power BI? Ask the Power BI experts at ArcherPoint. ![This is image...

Comparing Power BI with other tools

Our Power BI Training will provide you to learn the Power BI tools and making reports easily with realty. Our Power BI Course also includes live sessions, live Pro

Power BI vs Tableau

Our Power BI Training will provide you to learn the Power BI tools and making reports easily with realty. Our Power BI Course also includes live sessions, live Pro

Which Is Better? Power BI Vs. Tableau

Our Power BI Training will provide you to learn the Power BI tools and making reports easily with realty. Our Power BI Course also includes live sessions, live Pro