Purpose:

The Python script updates a DataFrame by copying yesterday’s publication cost into a specific column for structured budget allocation purposes.

To Elaborate

The Python script is designed to facilitate the process of structured budget allocation (SBA) by ensuring that the cost data from the previous day is accurately tagged and transferred within a DataFrame. This is crucial for businesses that need to track and manage their advertising expenses efficiently. The script takes an input DataFrame containing various columns related to campaign and account details, along with the publication cost. It then duplicates this DataFrame and updates a specific column to reflect the cost incurred yesterday. This operation helps in maintaining a clear record of daily expenses, which is essential for budget planning and financial analysis.

Walking Through the Code

1. DataFrame Duplication:
   • The script begins by creating a copy of the input DataFrame (inputDf) and assigns it to outputDf. This ensures that the original data remains unchanged while modifications are made to the duplicate.
2. Column Update:
   • The script updates the BULK_COL_YESTERDAYS_COST column in the outputDf DataFrame by copying the values from the RPT_COL_PUB_COST column. This step is crucial for tagging yesterday’s cost data accurately.
3. Output Display:
   • Finally, the script uses the tableize function to print the updated DataFrame, allowing users to visually verify the changes made to the cost data.

Vitals

• Script ID : 203
• Client ID / Customer ID: 1306915623 / 45606
• Action Type: Bulk Upload
• Item Changed: Campaign
• Output Columns: Account, Campaign, Yesterdays Cost
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Autumn Archibald (aarchibald@marinsoftware.com)
• Created by Autumn Archibald on 2023-06-16 16:04
• Last Updated by Autumn Archibald 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
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_PUB_COST = 'Pub. Cost $'
RPT_COL_YESTERDAYS_COST = 'Yesterdays Cost'
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_YESTERDAYS_COST = 'Yesterdays Cost'

outputDf = inputDf.copy()
outputDf[BULK_COL_YESTERDAYS_COST] = outputDf[RPT_COL_PUB_COST]


print(tableize(outputDf))

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