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 simplicity, these examples use the default installation of Python from python.org, simply using the Idle shell in its default setting. To see our video on how to install Pandas, look here: https://www.youtube.com/watch?v=mlzWbimEwEw 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 https://www.youtube.com/watch?v=mlzWbimEwEw How to Filter and Sort a Pandas DataFrame You are watching this video now! How to Create Summary Statistics in Pandas https://www.youtube.com/watch?v=ceIQTbA0rbs How to Append Two Pandas DataFrames Together https://www.youtube.com/watch?v=KzK-yfkB4Fc How to Merge Pandas Dataframes in Python https://www.youtube.com/watch?v=IjGGx-xdMqw Excel to Access Using Python Pandas https://www.youtube.com/watch?v=7H4MVZBWFto How to Group Pandas Data with Totals https://www.youtube.com/watch?v=QuZTECujzTk CSV to Microsoft Access Using Python and Pandas https://www.youtube.com/watch?v=_fvCKUs4k30 Follow us on social media: https://www.facebook.com/mackenziedataanalytics/ https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering 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