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. It achieves this by copying the relevant cost data from a specified column in the input DataFrame to a designated column in the output DataFrame. This process is essential for ensuring that the cost data is accurately reflected in the bulk data format, which can then be used for further analysis or reporting purposes. The script is particularly useful in scenarios where cost data needs to be consistently updated and aligned across different data formats.

Walking Through the Code

1. Data Preparation:
   • The script begins by creating a copy of the input DataFrame, inputDf, to outputDf. This ensures that the original data remains unchanged while modifications are made to the copy.
2. Data Transfer:
   • The script transfers the cost data from the ‘Pub. Cost $’ column in the report format to the ‘Yesterdays Cost’ column in the bulk data format. This is done by assigning the values from RPT_COL_PUB_COST to BULK_COL_YESTERDAYS_COST in the outputDf.
3. Output:
   • Finally, the script prints the modified DataFrame using the tableize function, which likely formats the DataFrame for display or further processing.

Vitals

• Script ID : 179
• Client ID / Customer ID: 1306920365 / 45606
• Action Type: Bulk Upload
• Item Changed: Campaign
• Output Columns: Account, Campaign, Yesterdays Cost
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Byron Porter (bporter@marinsoftware.com)
• Created by Byron Porter on 2023-06-07 20:42
• Last Updated by Aaron Thomas 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