Purpose:

The Python script transfers values from the “Portfolio” column to the “Amazon Portfolio” column in a dataset.

To Elaborate

The Python script is designed to automate the process of updating a dataset by copying values from one column to another. Specifically, it takes the values from the “Portfolio” column and inserts them into the “Amazon Portfolio” column within the same dataset. This operation is useful for ensuring that the “Amazon Portfolio” column reflects the current values of the “Portfolio” column, which might be necessary for reporting or data consistency purposes. The script is straightforward and focuses on this single task without additional data manipulation or complex logic.

Walking Through the Code

1. Initialization: The script begins by defining the current date using the datetime module, although this is not directly used in the main functionality of the script. It then sets up the primary data source by accessing a dictionary dataSourceDict with a key “1” to retrieve the input DataFrame inputDf.

2. Column Definitions: Several column names are defined as constants, which are used later in the script to reference specific columns in the DataFrame. These include ‘Campaign’, ‘Account’, ‘Portfolio’, and ‘Amazon Portfolio’.

3. Processing Function: The core functionality is encapsulated in the process function. This function takes the input DataFrame, creates a copy of it, and then assigns the values from the “Portfolio” column to the “Amazon Portfolio” column. This operation is performed using simple DataFrame column assignment.

4. Output and Debugging: After the column assignment, the script prints the modified DataFrame for debugging purposes, allowing the user to verify the changes made.

5. Execution: Finally, the script calls the process function with inputDf as an argument, storing the result in outputDf. This triggers the main operation of copying the column values.

Vitals

• Script ID : 1453
• Client ID / Customer ID: 1306927459 / 50395
• Action Type: Bulk Upload
• Item Changed: Campaign
• Output Columns: Account, Campaign, Amazon Portfolio
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Jeremy Brown (jbrown@marinsoftware.com)
• Created by Jeremy Brown on 2024-10-24 14:32
• Last Updated by Jeremy Brown on 2024-10-24 14:33

> See it in Action

Python Code

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
##
## Name: Insert Portfolio into Amazon Portfolio
## description: Insert the value from the "Portfolio" column into the "Amazon Portfolio" dimension column.
## 
## author: Jeremy Brown 
## created: 2024-10-24
##

today = datetime.datetime.now(CLIENT_TIMEZONE).date()

# primary data source and columns
inputDf = dataSourceDict["1"]
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_PORTFOLIO = 'Portfolio'
RPT_COL_AMAZON_PORTFOLIO = 'Amazon Portfolio'

# Function to process the input DataFrame and return the output DataFrame
def process(inputDf):
    # Copy the input DataFrame to the output DataFrame
    outputDf = inputDf.copy()

    # Insert the value from the "Portfolio" column into the "Amazon Portfolio" column
    outputDf[RPT_COL_AMAZON_PORTFOLIO] = outputDf[RPT_COL_PORTFOLIO]
    
    # Print the changed data for debugging
    print(outputDf)

    return outputDf

# Trigger the main process
outputDf = process(inputDf)

Post generated on 2025-03-11 01:25:51 GMT