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 moreUse Python to automate office tasks
A common task in machine learning is to split the train and test datasets, we’ll take a look at how[…]
Read moreIn 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 moreThis tutorial will walk through how to perform the SUMIF and COUNTIF Excel functions using the Python pandas library. SUMIF[…]
Read moreIn this tutorial, we’ll combine sheets from different Excel files into a single workbook but still separate sheets using Python.[…]
Read moreIn this tutorial, we’ll learn how to merge multiple Excel files in Python. The “merge” operation refers to combining files[…]
Read moreToday we’ll talk about how to connect and work with the SQLite database using Python. In case you have never[…]
Read moreIn Python, the pandas groupby() function provides a convenient way to summarize data in any way we want. The function[…]
Read moreIf your job requires working with large amount of data in Excel, and needing to match up certain records from[…]
Read moreExcel LOOKUP formulas are probably one of the most used formulas (at least for me). So today we’ll replicate the[…]
Read moreWe previously talked about how to create calculated columns in pandas, and walked through some simple examples. We can create[…]
Read more