Apr-30-2020, 03:50 PM
(This post was last modified: Apr-30-2020, 03:50 PM by alexafshari.)
Hi Everyone,
I`m struggling to find a solution to resolve my issue regarding assign some data from one series of a dataset to a specific column. You can see the excel file at the below link, I have illustrated what I have and what I want.
My DataSample
Please excuse amateur coding literacy.
I have two General Data Columns: 1) General data&time 2)General Attraction
Also, I have two other Individual Customer Columns (User Data): 1) Customer data&time 2) Profit of Customer
I want to assign data from General Data to User Data with equal or the closest timing that matched and create a new 4 columns 1)matched data & time 2) general attraction, timing wised associated to the user 3)user data & time. 4)profit
Would you please help me how can I resolve this problem with python?
Thanks in advance
I`m struggling to find a solution to resolve my issue regarding assign some data from one series of a dataset to a specific column. You can see the excel file at the below link, I have illustrated what I have and what I want.
My DataSample
Please excuse amateur coding literacy.
I have two General Data Columns: 1) General data&time 2)General Attraction
Also, I have two other Individual Customer Columns (User Data): 1) Customer data&time 2) Profit of Customer
I want to assign data from General Data to User Data with equal or the closest timing that matched and create a new 4 columns 1)matched data & time 2) general attraction, timing wised associated to the user 3)user data & time. 4)profit
Would you please help me how can I resolve this problem with python?
Thanks in advance