From the course: SQL Server Machine Learning Services: Python

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Get descriptive statistics with pandas

Get descriptive statistics with pandas

From the course: SQL Server Machine Learning Services: Python

Start my 1-month free trial

Get descriptive statistics with pandas

“

- [Instructor] Anytime you're working with data frames in Python you're making use of the Pandas library. There's a lot of different things that 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 Wide-World Importers database. I've written a query here at the top of the screen that sums 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…

Contents