Purpose:

The Python script updates a DataFrame by copying yesterday’s cost data from one column to another.

To Elaborate

The Python script is designed to process a DataFrame by transferring cost data from a specified column to another column labeled as “Yesterday’s Cost.” This operation is typically used in financial reporting or budget tracking scenarios where it is necessary to maintain a record of costs incurred on the previous day. The script ensures that the cost data is accurately reflected in the designated column, which can be crucial for tasks such as daily budget reconciliation or cost analysis. The script is straightforward, focusing solely on the data transfer between columns without additional data manipulation or complex logic.

Walking Through the Code

1. DataFrame Copying:
   • 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. Column Data Transfer:
   • The script transfers data from the column labeled ‘Pub. Cost $’ to the column ‘Yesterdays Cost’ within the outputDf. This operation is performed by directly assigning the values from one column to another, ensuring that the cost data is updated accurately.
3. Output Display:
   • Finally, the script uses a function tableize to print the updated DataFrame, allowing users to visually verify the changes made to the data.

Vitals

• Script ID : 207
• Client ID / Customer ID: 94357244 / 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:13
• 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