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, it takes the public cost from a report and assigns it to a column labeled as “Yesterday’s Cost” in a new data frame. This transformation is crucial for ensuring that cost data is accurately reflected in the bulk data format, which may be used for further analysis or reporting. The script essentially prepares the data for subsequent operations by aligning the cost information with the required structure.

Walking Through the Code

1. Data Preparation:
   • The script begins by creating a copy of the input data frame (inputDf) to ensure that the original data remains unchanged. This copy is stored in outputDf.
2. Data Transformation:
   • It then assigns the values from the ‘Pub. Cost $’ column of the report data frame to the ‘Yesterday’s Cost’ column in the bulk data format. This step ensures that the cost data is correctly transferred and aligned with the expected structure.
3. Output:
   • Finally, the script prints the transformed data frame using the tableize function, which likely formats the data for easy viewing or further processing.

User changeable parameters include the column names used for mapping data, allowing flexibility in adapting the script to different data structures or naming conventions.

Vitals

• Script ID : 197
• Client ID / Customer ID: 716863461 / 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-15 18:11
• 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