Purpose:

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

To Elaborate

The Python 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 particularly useful in scenarios where financial data needs to be restructured for analysis or reporting purposes. The script takes an input DataFrame, which contains various columns including campaign and account details, and copies the public cost data into a new column labeled as yesterday’s cost. This transformation allows for consistent and structured budget allocation (SBA) analysis, ensuring that financial data is accurately represented and easily accessible for further processing or decision-making.

Walking Through the Code

1. Data Preparation
   • The script begins by creating a copy of the input DataFrame, inputDf, to ensure that the original data remains unchanged during processing. This is stored in a new DataFrame called outputDf.
2. Data Transformation
   • The script then assigns the values from the ‘Pub. Cost $’ column of the report to the ‘Yesterdays Cost’ column in the bulk data format. This step is crucial for aligning the data structure with the requirements for further analysis or reporting.
3. Output Generation
   • Finally, the script uses the tableize function to print the transformed DataFrame, outputDf, which now includes the updated ‘Yesterdays Cost’ column. This provides a visual representation of the data transformation for verification and further use.

Vitals

• Script ID : 209
• Client ID / Customer ID: 85764212 / 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:16
• 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