Filtering and Selection with Dataframes

In this project you'll learn how to query the data in a DataFrame by creating different filtering expressions. You'll be able to answer your own questions by using different boolean and comparison operators. Being able to write effective queries for DataFrames is a fundamental skill in Data Analysis.

codevalidated

Select companies in the Sector 'Software Services'

Create an expression to select those companies which Sector is "Software Services". Store your result in the variable df_software.

codevalidated

Select those companies with less Employees than Apple

Perform a selection of those companies that have less Employees than Apple and store the result in df_low_employees.

codevalidated

Filter companies with Revenue above the average

Select the companies that have a Revenue value above the mean/average. Store your results in the variable df_high_revenue.

codevalidated

Select non-American companies with Employees above the mean

Perform a selection of all the companies that have an Employee count above the mean, and country is NOT USA. Store your results in a variable df_employee_non_usa.

codevalidated

Find those non-american companies with Revenue per Employee below the median

Perform a selection of the companies with Revenue per Employee below the median and from a Country that is not the USA. Store your results in the variable df_low_rev_employee.

codevalidated

American companies, from 'Software Services' sector, that have Revenue/employee above the mean

Perform a selection of companies in the Sector "Software Services", from the "USA", and that have a Revenue per Employee value greater than the mean. Store your result in the variable df_usa_software_high_efficiency

Filtering and Selection with Dataframes

Santiago Basulto

Project Activities

Select companies in the Sector 'Software Services'

Select those companies with less Employees than Apple

Filter companies with Revenue above the average

Select non-American companies with Employees above the mean

Find those non-american companies with Revenue per Employee below the median

American companies, from 'Software Services' sector, that have Revenue/employee above the mean

Santiago Basulto

Intro to Pandas for Data Analysis

Set Operations using Sakila

LIKE Operator using World

Membership and Range Operators with World Database

Filtering and Selection with Dataframes

Santiago Basulto

Project Activities

Select companies in the Sector 'Software Services'

Select those companies with less Employees than **Apple**

Filter companies with Revenue above the average

Select non-American companies with Employees above the mean

Find those non-american companies with Revenue per Employee below the median

American companies, from 'Software Services' sector, that have Revenue/employee above the mean

Santiago Basulto

Intro to Pandas for Data Analysis

Set Operations using Sakila

LIKE Operator using World

Membership and Range Operators with World Database

Select those companies with less Employees than Apple