Explore the Moonbooks open science library

Article

How to Duplicate and Repeat a 1D Column Array Along the Y-Axis with NumPy

By Benjamin Marchant Updated Dec 14, 2024

Public Open →

Article

How to extract longitudes and latitudes from a geometry column with points within a GeoPandas DataFrame ?

By Benjamin Marchant Updated Feb 12, 2024

Python Geopandas

Public Open →

Article

How to retrieve data from a Bokeh ColumnDataSource ?

By Benjamin Marchant Updated Jan 9, 2024

Python Bokeh

Public Open →

Article

How to retrieve the minimum and maximum dates (i.e., start and end dates) from a datetime column in a pandas dataframe ?

By Benjamin Marchant Updated Jan 6, 2024

Python Pandas Dataframe

Public Open →

Article

How to efficiently obtain statistical measures (such as mean, standard deviation, count, etc.) for a specific column in a pandas dataframe using describe() ?

By Benjamin Marchant Updated Jan 1, 2024

Python Pandas Dataframe

Public Open →

Article

How to convert a MultiIndex column into a single index column in a pandas dataframe?

By Benjamin Marchant Updated Dec 30, 2023

Python Pandas Dataframe

Public Open →

Article

How to retrieve table column names in a Sqlite database using python and SQLAlchemy ?

By Benjamin Marchant Updated Apr 27, 2023

Python SQLAlchemy

Public Open →

Article

How to retrieve the column names of a table in Sqlite database ?

By Benjamin Marchant Updated Apr 27, 2023

SQL Sqlite3

Public Open →

Article

How to apply a function to the values of a column array using numpy ?

By Benjamin Marchant Updated Apr 8, 2023

Python Numpy

Public Open →

Article

How to get data type of each column in a Pandas DataFrame ?

By Benjamin Marchant Updated Apr 7, 2023

Python Pandas Dataframe

Public Open →

Article

How to find the most frequent value in a pandas DataFrame column ?

By Benjamin Marchant Updated Mar 22, 2023

Python Pandas Dataframe

Public Open →

Article

How to slice a multidimensional matrix on column values with numpy ?

By Benjamin Marchant Updated Mar 13, 2023

Python Numpy

Public Open →

Article

How to sort values within a column of a pandas dataframe ?

By Benjamin Marchant Updated Mar 13, 2023

Python Pandas DataFrame

Public Open →

Article

How to drop duplicate rows in Pandas based on column value

By Benjamin Marchant Updated Mar 7, 2023

Python Pandas DataFrame

Public Open →

Article

How to merge multiple Pandas DataFrames based on multiple columns ?

By Benjamin Marchant Updated Feb 21, 2023

Python Pandas Dataframe

Public Open →

Article

How to apply a function to an individual or multiple columns of a pandas DataFrame ?

By Benjamin Marchant Updated Feb 20, 2023

Pandas python

Public Open →

Article

How to apply a function across multiple columns in a pandas DataFrame and create several new ones ?

By Benjamin Marchant Updated Feb 20, 2023

Python Pandas Dataframe

Public Open →

Article

Get the absolute difference between two pandas dataframe columns

By Benjamin Marchant Updated Feb 19, 2023

Python Pandas Dataframe

Public Open →

Article

How to get the absolute value of a dataframe column in pandas ?

By Benjamin Marchant Updated Dec 9, 2022

Python Pandas DataFrame

Public Open →

Article

How to select dataframe columns that end with *** with pandas ?

By Benjamin Marchant Updated Dec 9, 2022

Python Pandas DataFrame

Public Open →

Article

How to find all dataframe columns that contain a given word with pandas ?

By Benjamin Marchant Updated Dec 9, 2022

Python Pandas DataFrame

Public Open →

Article

How to create a new column of initials from a full name dataframe column with pandas and python ?

By Benjamin Marchant Updated Dec 9, 2022

Python Pandas DataFrame Regex

Public Open →

Article

How to split a full name column into a first and last name columns with pandas in python ?

By Benjamin Marchant Updated Dec 9, 2022

Python Pandas DataFrame

Public Open →

Article

How to merge (concatenate) two or more dataframe columns into one column with pandas ?

By Benjamin Marchant Updated Dec 9, 2022

Python Pandas DataFrame

Public Open →

Article

How to apply a one hot encoding to a pandas dataframe categorical data column using get_dummies() ?

By Benjamin Marchant Updated Dec 9, 2022

Python Pandas Machine Learning

Public Open →

Article

How to replace dataframe columns by another dataframe columns with pandas ?

By Benjamin Marchant Updated Dec 9, 2022

Python Pandas DataFrame

Public Open →

Article

How to convert a column of float (quantitative data) into categorical data with pandas using cut ?

By Benjamin Marchant Updated Sep 9, 2022

Python Pandas DataFrame

Public Open →

Article

How to create a datetime column from year, month and day columns in pandas ?

By Benjamin Marchant Updated Nov 29, 2021

Python Pandas DataFrame

Public Open →

Article

How to shift values in a dataframe column with pandas ?

By Benjamin Marchant Updated Sep 27, 2021

Python Pandas DataFrame

Public Open →

Article

How to sum multiple columns together of a dataframe with pandas in python ?

By Benjamin Marchant Updated Aug 30, 2021

Python Pandas DataFrame

Public Open →

Article

How to use a dataframe column as index with pandas ?

By Benjamin Marchant Updated Aug 11, 2021

Python Pandas DataFrame Index Column

Public Open →

Article

How to iterate over a column in a numpy array (or 2D matrix) in python ?

By Benjamin Marchant Updated Apr 12, 2021

Python Numpy Array Matrix

Public Open →

Article

How to slice (split) a dataframe by column value with pandas in python ?

By Benjamin Marchant Updated Apr 7, 2021

Python Pandas DataFrame

Public Open →

Article

How to convert a dataframe column to an array with pandas ?

By Benjamin Marchant Updated Mar 30, 2021

Python Pandas DataFrame

Public Open →

Article

How to add a new column of nan values in an array (matrix) with numpy in python ?

By Benjamin Marchant Updated Mar 24, 2021

Python Numpy

Public Open →

Article

How to add an empty column to an existing dataframe with pandas ?

By Benjamin Marchant Updated Mar 18, 2021

Python Pandas DataFrame

Public Open →

Article

How to check if two columns are equal (identical) with pandas ?

By Benjamin Marchant Updated Mar 3, 2021

Python Pandas DataFrame

Public Open →

Article

How to get column index from column name with pandas ?

By Benjamin Marchant Updated Feb 23, 2021

Python Pandas DataFrame

Public Open →

Article

How to remove (drop) duplicate columns with pandas ?

By Benjamin Marchant Updated Feb 22, 2021

Python Pandas DataFrame

Public Open →

Article

How to add multiple columns to a dataframe with pandas ?

By Benjamin Marchant Updated Feb 22, 2021

Python Pandas DataFrame

Public Open →

Article

How to create a scatter plot using two columns of a dataframe with pandas in python ?

By Benjamin Marchant Updated Dec 21, 2020

Python Pandas DataFrame

Public Open →

Article

How to create and plot a confusion matrix (or crosstab) from two dataframe columns using pandas in python ?

By Benjamin Marchant Updated Dec 16, 2020

Python Pandas DataFrame

Public Open →

Article

How to get the max value of two or more columns in a pandas dataframe ?

By Benjamin Marchant Updated Oct 1, 2020

Python Pandas DataFrame

Public Open →

Article

How to count the number of NaN in a pandas dataframe column ?

By Benjamin Marchant Updated Aug 1, 2020

Python Pandas DataFrame

Public Open →

Article

How to find all unique values in a dataframe column with pandas ?

By Benjamin Marchant Updated Jul 30, 2020

Python Pandas DataFrame

Public Open →

Explore notebooks, articles and scientific resources

Search results

How to Duplicate and Repeat a 1D Column Array Along the Y-Axis with NumPy

How to extract longitudes and latitudes from a geometry column with points within a GeoPandas DataFrame ?

How to retrieve data from a Bokeh ColumnDataSource ?

How to retrieve the minimum and maximum dates (i.e., start and end dates) from a datetime column in a pandas dataframe ?

How to efficiently obtain statistical measures (such as mean, standard deviation, count, etc.) for a specific column in a pandas dataframe using describe() ?

How to convert a MultiIndex column into a single index column in a pandas dataframe?

How to split qualitative and categorical data columns in a pandas dataframe ?

How to select columns of a pandas Dataframe based on their data types ?

How to merge two pandas dataframes and sum values of the shared columns ?

How to transpose a pandas dataframe to switch its rows and columns ?

How to rearrange the order of the columns in a Pandas DataFrame ?

How to retrieve table column names in a Sqlite database using python and SQLAlchemy ?

How to retrieve the column names of a table in Sqlite database ?

How to apply a function to the values of a column array using numpy ?

How to get data type of each column in a Pandas DataFrame ?

How to find the most frequent value in a pandas DataFrame column ?

How to slice a multidimensional matrix on column values with numpy ?

How to sort values within a column of a pandas dataframe ?

How to drop duplicate rows in Pandas based on column value

How to merge multiple Pandas DataFrames based on multiple columns ?

How to apply a function to an individual or multiple columns of a pandas DataFrame ?

How to apply a function across multiple columns in a pandas DataFrame and create several new ones ?

Get the absolute difference between two pandas dataframe columns

How to get the absolute value of a dataframe column in pandas ?

How to select dataframe columns that end with *** with pandas ?

How to find all dataframe columns that contain a given word with pandas ?

How to create a new column of initials from a full name dataframe column with pandas and python ?

How to split a full name column into a first and last name columns with pandas in python ?

How to merge (concatenate) two or more dataframe columns into one column with pandas ?

How to apply a one hot encoding to a pandas dataframe categorical data column using get_dummies() ?

How to replace dataframe columns by another dataframe columns with pandas ?

How to convert a column of float (quantitative data) into categorical data with pandas using cut ?

How to create a datetime column from year, month and day columns in pandas ?

How to shift values in a dataframe column with pandas ?

How to sum multiple columns together of a dataframe with pandas in python ?

How to use a dataframe column as index with pandas ?

How to iterate over a column in a numpy array (or 2D matrix) in python ?

How to slice (split) a dataframe by column value with pandas in python ?

How to convert a dataframe column to an array with pandas ?

How to add a new column of nan values in an array (matrix) with numpy in python ?

How to add an empty column to an existing dataframe with pandas ?

How to check if two columns are equal (identical) with pandas ?

How to get column index from column name with pandas ?

How to remove (drop) duplicate columns with pandas ?

How to add multiple columns to a dataframe with pandas ?

How to create a scatter plot using two columns of a dataframe with pandas in python ?

How to create and plot a confusion matrix (or crosstab) from two dataframe columns using pandas in python ?

How to get the max value of two or more columns in a pandas dataframe ?

How to count the number of NaN in a pandas dataframe column ?

How to find all unique values in a dataframe column with pandas ?