Assigning Data from one column to another with different associated timing interval - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: General Coding Help (https://python-forum.io/forum-8.html) +--- Thread: Assigning Data from one column to another with different associated timing interval (/thread-26405.html) |
Assigning Data from one column to another with different associated timing interval - alexafshari - Apr-30-2020 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 RE: Assigning Data from one column to another with different associated timing interval - pyzyx3qwerty - Apr-30-2020 What have you tried? Show us and we will be able to help you |