Skip to content ▶ Group Assignments & Presentation Info ▶ Labs ▶ Lab 1: NumPy Arrays ▶ Lab 2: Exploring Summary Statistics with Pandas ▶ Lab 3: Filtering and Sorting ▶ Lab 4: groupby() ▶ Lab 5: Reading Tables from an Azure SQL Database ▶ Lab 6: Matplotlib and Seaborn plots ▶ Lab 7: Bar Chart Labels ▶ Lab 8: Plots, Correlation and Regression ▶ 1 Getting Started ▶ Ex 1.1: Intro to Jupyter Notebooks ▶ 2 NumPy ▶ Ex 2.1: Intro to NumPy ▶ 2.2: Indexing and Slicing ▶ 3 Pandas ▶ Ex 3.1: Reading CSV Files ▶ Ex 3.2: Reading Excel Files ▶ Ex 3.3: Custom Datasets & Intro to Git ▶ Ex 3.4: Filtering ▶ Ex 3.5: Sorting and Top N ▶ Ex 3.6: Groupby Operations - One Column ▶ Ex 3.7: Groupby Operations - Two Columns ▶ Ex 3.8: Screenscraping and Data Cleansing ▶ Ex 3.9: Dealing with Missing Data ▶ Ex 3.10: Data Cleansing II and MCP Development ▶ Ex 3.11: Reading Tables from a Database ▶ 4 Visualizing Data with Python ▶ Ex 4.1: Matplotlib and Seaborn ▶ Ex 4.2: Working with Different Datasets ▶ Ex 4.3: Bokeh-LineChart ▶ Ex 4.4: Time Series and Bokeh Layouts ▶ Ex 4.5: Bar Charts with Plotly Express ▶ Ex 4.6: Formatting Bar Chart Labels with Plotly Express ▶ 5 Statistical Analysis and Visualization ▶ Ex 5.1: Basic Statistical Analysis ▶ Ex 5.2: Compute Correlations Among Variables ▶ 6 Dash & Scikit-Learn ▶ Ex 6.1: Dash App Layouts and Components ▶ Ex 6.2: Interactive Dash App with Callbacks ▶ Ex 6.3: Machine Learning with Scikit-Learn ▶ Ex 6.4: Classification Using Scikit-Learn
Download the Ex3.11_ReadingTablesFromADatabase.ipynb file.
Using the product_data.sqlite file, work through each of the steps in the Jupyter Notebook which should include both your code and the corresponding output that match the screengrabs of the completed steps 2, 4, and 5 provided below.
← Previous Building an MCP Server for Claude Desktop Next → Reading Tables from a Database