In the attached video below, I am simply showing the following 3 pieces of code with Jupyter Notebook: Remove spaces in dataframe columns. Remove none values from dataframe rows. Filter dataframes, based on values. E.g. – put all rows with …
Python – Remove spaces and None from pandas dataframe Read more »
Some time ago, probably yesterday or the day before, I had to filter a pandas dataframe and somehow it did not come intuitively into my mind how to do it. As I did not have an article about it, I …
Python – Filtering values from a Pandas DataFrame Read more »
The idea of the article is to provide a Python code that does the following: Takes a list or DataFrame; Splits it into quite a few smaller parts; Writes each one on a separate Excel worksheet; Pretty much like this: …
Python – Write a DataFrame or List to multiple tabs in Excel Read more »
Working with python, pandas and dataframes is quite challenging even for experienced Excel & VBA developer, as I love to consider myself for one. Thus, today I was fighting for quite some time to add new columns to a dataframe, …
Python – Building New Columns in a Dataframe, Based on Other Columns Read more »