Pandas extract numbers and floats from string
We want to extract the numbers, float and multiple numbers from a string column in a dataframe.
Blog
Pandas Add month, days, hours, minutes, Bday (business days) and year to date and also find out first day of Month and last day of month
We want to add Month, Days, Hours, Minutes or Year offset to a date column in a dataframe and also like to see how to find out the MonthBegin and MonthEnd da...
Tensorflow available GPU and it’s details
In this post we will see how to find all the available CPU and GPU devices on the host machine and get the device details and other info like it’s Memory usa...
Pandas compare columns in two data frames
We have two dataframes and a common column that we want to compare and find out the matching, missing values and sometimes the difference between the values ...
Pandas select rows and columns in MultiIndex dataframe
We want to select or slice the rows and columns of a MultiIndex dataframe. In this post we will take a look on how to slice the dataframe using the index at ...
Pandas filter dates by month, hour, day and last N days & weeks
We have dataframe with dates or timestamps columns and we would like to filter the rows by Month, Hour, day or by last n days from today’s date.
Pandas get row index that matches specific value in column or condition
We want to get index of rows that matches a specific column value or a condition based on multiple columns. The pandas index attribute get you the index of d...
How to change the date format and work with dates effectively in Matplotlib
We want to plot the data with date on x-axis but the dates are not in the required format for ex: your date column in the data is in YYYY-MM-DD format and yo...
Pandas define your own groupby aggregation functions
The .agg method does aggregation as it sounds and you can pass in the names of aggregation methods, Python aggregations, Numpy reduce functions and you can a...