Use Python Xlsxwriter To Create Excel Spreadsheet
In this tutorial, we’ll use Python to create a high-fidelity Excel spreadsheet. “High-fidelity” means that the Python-generated Excel spreadsheet will[…]
Read moreTag: Data Manipulation
How 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 Python lambda, map and filter functions
Python lambda function, aka anonymous function. Unlike how we create a function with def … statement, where we can name[…]
Read moreSort Excel data using Python
Sorting table is a common task in Excel. We sort a table in order to help us view or use[…]
Read moreSplit text to columns in Python
How many times have you had to split a text in Excel? I bet too many to count. Most Excel[…]
Read moreCreate calculated columns in a dataframe
In Excel, we can create a calculated column by first write a formula (in a cell), then drag down the[…]
Read moreRemove duplicates from a data table
In Excel, we can “easily” remove duplicates from a table by clicking on the “Remove Duplicates” button from the Data[…]
Read moreFilter a pandas dataframe – OR, AND, NOT
This is the second part of the Filter a pandas dataframe tutorial. Today we’ll be talking about advanced filter in[…]
Read moreFilter a pandas dataframe (think Excel filters but more powerful)
Being able to slice and dice the data is essential for working with data. Similar to the filter in Excel,[…]
Read morePython list indexing and slicing
I realize this is an important topic since we’ll be using these techniques a lot in pandas. Python list indexing[…]
Read more