How to Filter and Sort a Pandas DataFrame

In this episode, we return to our Python series and talk about how to query and sort our Pandas DataFrame, using data from MS Access for our example. As we start to use our DataFrames more, you’ll see the incredible flexibility and power that this module brings to Python, for analytics, ETL, and data pipelining.

We will look at how, once we have our data in memory, we can easily filter and sort our DataFrames for simple or complex conditions. There will be five examples in this video: query by a single field, query by two fields using ‘and’, query by two fields using ‘or’, sorting by one field (descending), and filtering by two fields.

For MS Access, you may need to install the free MS Access Runtime so that you have the necessary drivers for ODBC. Download it from Microsoft if you need it.

Let’s get to it!

Related Videos:
How to Install Pandas in Python
How to Filter and Sort a Pandas DataFrame
You are watching this video now!
How to Create Summary Statistics in Pandas
How to Append Two Pandas DataFrames Together
How to Merge Pandas Dataframes in Python
Excel to Access Using Python Pandas
How to Group Pandas Data with Totals
CSV to Microsoft Access Using Python and Pandas

Follow us on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

python sort accdb
python filter accdb
python pandas filter sort
python filter mdb data
python mdb
python mdb Microsoft access
pandas dataframe filter
pandas dataframe sort
python pandas query
pandas data frame query
python dataframe query
python pyodbc pandas
python pyodbc
python data analytics
pandas data analytics
pandas data analysis
sean mackenzie

Enter comma-separated values38

[sd]

Great video ! Thank you!
I do have a question for you. How to do higher level data analysis in python like calculating percentages once the connection to ms access is established ? Also, can we use pandas once we have connected to access database?
Thank you in advance!