Purpose:

The Python script assigns a specific label to campaigns based on certain conditions in a dataset.

To Elaborate

The Python script is designed to process a dataset of marketing campaigns and categorize them based on specific criteria. It checks if the campaign name contains the string ‘FR’ and if the campaign maturity status is not specified. If both conditions are met, the script assigns the label ‘France’ to the campaign maturity column for those specific entries. This helps in organizing and categorizing campaigns that meet these criteria, ensuring that they are correctly labeled for further analysis or reporting.

Walking Through the Code

1. Define Constants: The script begins by defining constants for column names used in the dataset. These constants are used to reference specific columns in the DataFrame, ensuring consistency and reducing the risk of errors due to typos.

2. Set Condition: A condition is established to identify rows in the dataset where the campaign name contains ‘FR’ and the campaign maturity is not specified. This is done using the str.contains method for string matching and isnull to check for missing values.

3. Filter and Assign: The script filters the dataset based on the defined condition. For the filtered rows, it assigns the value ‘France’ to the ‘Campaign Maturity’ column. This step effectively categorizes the campaigns that meet the criteria.

4. Output: Finally, the script prints the modified DataFrame, showing the campaigns that have been labeled as ‘France’. This output can be used for further analysis or reporting.

Vitals

• Script ID : 131
• Client ID / Customer ID: 1306922587 / 2
• Action Type: Bulk Upload (Preview)
• Item Changed: Campaign
• Output Columns: Account, Campaign, Campaign Maturity
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Byron Porter (bporter@marinsoftware.com)
• Created by Byron Porter on 2023-05-24 19:45
• Last Updated by Byron Porter on 2023-12-06 04:01

> See it in Action

Python Code

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_CAMPAIGN_MATURITY = 'Campaign Maturity'
RPT_COL_CAMPAIGN_STATUS = 'Campaign Status'
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_CAMPAIGN_MATURITY = 'Campaign Maturity'

# Check if RPT_COL_CAMPAIGN has the string 'GINSU' and RPT_COL_CAMPAIGN_MATURITY is blank
condition = (inputDf[RPT_COL_CAMPAIGN].str.contains('FR', case=True, na=False)) & (inputDf[RPT_COL_CAMPAIGN_MATURITY].isnull())

# Assign 'YahooDSP' to the 'Campaign Maturity' column in outputDf where the conditions are true
outputDf = inputDf.loc[condition, [BULK_COL_ACCOUNT, BULK_COL_CAMPAIGN, BULK_COL_CAMPAIGN_MATURITY]]
outputDf.loc[:, BULK_COL_CAMPAIGN_MATURITY] = 'France'

# Print the tableized version of the output DataFrame
print(tableize(outputDf))

Post generated on 2025-03-11 01:25:51 GMT