From the course: Complete Guide to Advanced SQL Server

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Get descriptive statistics with pandas

Get descriptive statistics with pandas - SQL Server Tutorial

From the course: Complete Guide to Advanced SQL Server

Start my 1-month free trial Buy for my team

Get descriptive statistics with pandas

“

Anytime you're working with data frames in Python, you're making use of the pandas library. There's a lot of different things you can do with a data frame, including merging multiple data frames, sorting and aggregating rows, transforming the data frame into different configurations, or changing the values throughout the data frame. One of the other things that we can do is get descriptive statistics about the entire data frame, in order to get an understanding of the size and the range of the values that it contains. Let's start by taking a look at some of the data that's stored in the WideWorldImporters database. I've written a query here at the top of the screen that sums up the total dollar amount of each order in the database. If you execute the query, you'll see a column for the order ID and the order total for over 73,000 orders. Now, I'd like to get some descriptive statistics about this information, and I can use the pandas library to help me out. First, I'm going to cut the…

Contents