How to Do Train Test Split in Sklearn
A common task in machine learning is to split the train and test datasets, we’ll take a look at how[…]
Read moreCategory: machine learning
Use Python To Concatenate Excel Files
In this tutorial, we’ll learn how to use Python to concatenate/append/merge/combine multiple Excel files. Programming languages keep evolving, and Python/pandas[…]
Read more
SUMIF And COUNTIF In Pandas
This tutorial will walk through how to perform the SUMIF and COUNTIF Excel functions using the Python pandas library. SUMIF[…]
Read more
Combine Excel Sheets Using Python
In this tutorial, we’ll combine sheets from different Excel files into a single workbook but still separate sheets using Python.[…]
Read more
How to merge multiple Excel files in Python
In this tutorial, we’ll learn how to merge multiple Excel files in Python. The “merge” operation refers to combining files[…]
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 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 moreReplicate Excel VLOOKUP, HLOOKUP, XLOOKUP in Python (DAY 30!!)
Excel LOOKUP formulas are probably one of the most used formulas (at least for me). So today we’ll replicate the[…]
Read moreCreate complex calculated columns using applymap()
We previously talked about how to create calculated columns in pandas, and walked through some simple examples. We can create[…]
Read more