Purpose:

The Python script transfers yesterday’s cost data from a report to a bulk data format for further processing.

To Elaborate

The script is designed to facilitate the transfer of cost data from a report format to a bulk data format, specifically focusing on the cost incurred yesterday. This is achieved by copying the ‘Pub. Cost $’ column from the input data frame to the ‘Yesterdays Cost’ column in the output data frame. The script ensures that the cost data is preserved and correctly tagged for further analysis or processing, which is crucial for maintaining accurate financial records and budget allocations, such as in Structured Budget Allocation (SBA) processes.

Walking Through the Code

1. Data Preparation
   • The script begins by creating a copy of the input data frame, inputDf, to outputDf. This ensures that the original data remains unchanged while modifications are made to the copy.
2. Data Transformation
   • The script then assigns the values from the ‘Pub. Cost $’ column of the outputDf to the ‘Yesterdays Cost’ column. This step effectively tags the cost data from the previous day for further use.
3. Output
   • Finally, the script prints the transformed data frame using the tableize function, which formats the data for easy viewing and verification.

Vitals

• Script ID : 201
• Client ID / Customer ID: 94831459 / 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:02
• 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