There is not a column 'customersince' Notebook C4_W2_lab_1

[Bradley_Cardenas]

In the notebook there is a reference to column ‘customersince’ for example:

# Create the column with the difference between the `current_date` value and the `customersince` column of the `users_df` dataframe
# Convert the value in days by applying `dt.days` method and make an integer division by 365
users_df['loyalty_program_years'] = (current_date - users_df['customersince']).dt.days // None

but in the query from glue job file (de-c4w2lab1-etl-glue-job.py) there is not that column

select r.customerNumber
, c.city
, c.state
, c.postalCode
, c.country
, c.creditLimit
, r.productCode
, p.productLine
, p.productScale
, p.quantityInStock
, p.buyPrice
, p.MSRP
, r.productRating
from ratings r 
join products p on p.productCode = r.productCode 
join customers c on c.customerNumber = r.customerNumber;

So it cannot be used to transform the data

[Amir_Zare]

Hello @Bradley_Cardenas
You are supposed to add the customersince column to the query yourself. Please, refer to the instructions in part 2.2.