00:00

4006. Filter Enterprise Active Organizations

MediumPYTHON133 / 1584

Relevant companies

Salesforce

Microsoft

Databricks

Snowflake

Atlassian

HubSpot

ServiceNow

Workday

Zendesk

Palantir

Datadog

Twilio

Okta

Veeva

Qualtrics

Zuora

Mixpanel

Amplitude

Dropbox

Monday.com

4006. Filter Enterprise Active Organizations

Medium133 / 1584

Relevant companies

Salesforce

Microsoft

Databricks

Snowflake

Atlassian

HubSpot

ServiceNow

Workday

Zendesk

Palantir

Datadog

Twilio

Okta

Veeva

Qualtrics

Zuora

Mixpanel

Amplitude

Dropbox

Monday.com

Sign in to Practice

Write SQL and Python, run instantly in your browser, and track your progress.

Runs live in your browser — no setup
Save progress across all 1,500+ problems
Submit and validate your answer instantly

Business Problem

You are a Customer Success Manager at Salesforce. The Enterprise Sales team needs a list of all active enterprise-tier clients for a strategic account review. Filter the organizations DataFrame to find companies that are both active AND classified as enterprise size.

Schema: organizations

Column Name	Type
org_id	int64
org_code	object
org_name	object
industry	object

Business Problem

Schema: organizations

Column Name	Type
org_id	int64
org_code	object
org_name	object
industry	object

Filter Enterprise Active Organizations — Python Medium | Let's Data Science | Let's Data Science

org_id	org_name	industry	size_bucket	status
18	Azure Data	manufacturing	enterprise	active
23	Coral Industries	healthtech	enterprise	active
28	Emerge Automation	govtech	enterprise	active

org_id	org_name	industry	size_bucket	status
18	Azure Data	manufacturing	enterprise	active
23	Coral Industries	healthtech	enterprise	active
28	Emerge Automation	govtech	enterprise	active

4006. Filter Enterprise Active Organizations

Relevant companies

Tags

4006. Filter Enterprise Active Organizations

Relevant companies

Tags

Sign in to Practice