Exploratory Data Analysis Tutorial With Sweetviz
In this tutorial, we’ll learn exploratory data analysis (EDA) with a Python library called sweetviz. Several alternative tools for EDA[…]
Read moreCategory: Intermediate
Use Python To Send WhatsApp Message
Not everyone checks email regularly so we are also going to use Python to send Whatsapp messages to ourselves when[…]
Read moreHow To Use Virtual Environment And Jupyter Notebook
In this short tutorial, we’ll talk about how to use a Python Virtual Environment (venv) and the Jupyter Notebook. We’ll[…]
Read morePython Xlsxwriter Create Excel Part 4 Conditional Formatting
The Python xlsxwriter library is capable of creating all sorts of conditional formatting for our Excel file. Let’s take a[…]
Read morePython Xlsxwrite Create Excel Part 3 (Format, Sparkline & Chart)
Building upon our previous file, we’ll use Python xlsxwriter library to beautify our boring-looking Excel spreadsheet by adding formatting, sparkline,[…]
Read morePython Xlsxwriter Create Excel Part 2 (Formula, Link & Named Range)
Xlsxwriter is a powerful library that can recreate most of the features of Excel, including formula, link, and named range.[…]
Read moreHow To Connect And Work With SQLite Database Using Python sqlite3
Today we’ll talk about how to connect and work with the SQLite database using Python. In case you have never[…]
Read moreFreeze Your Python Code – How to Run Python Script Without Python Installed
Do you know that you can “freeze” your python code and give other people run it even if they don’t[…]
Read moreHow To Use Pandas Groupby To Summarize Data
In Python, the pandas groupby() function provides a convenient way to summarize data in any way we want. The function[…]
Read moreUse fuzzy string matching in pandas
If your job requires working with large amount of data in Excel, and needing to match up certain records from[…]
Read more