Python Forum
Assigning Data from one column to another with different associated timing interval
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Assigning Data from one column to another with different associated timing interval
#1
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
Reply


Messages In This Thread
Assigning Data from one column to another with different associated timing interval - by alexafshari - Apr-30-2020, 03:50 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Returning Column and Row Data From Spreadsheet knight2000 0 478 Oct-22-2023, 07:07 AM
Last Post: knight2000
  Database that can compress a column, or all data, automatically? Calab 3 1,253 May-22-2023, 03:25 AM
Last Post: Calab
  Code for pullng all data in a column EmBeck87 5 1,180 Apr-03-2023, 03:43 PM
Last Post: deanhystad
  Mapping a value to an interval JazonKuer 12 2,110 Mar-17-2023, 07:59 PM
Last Post: Gribouillis
Question Timing actions with Python dangermaus33 0 1,029 Apr-19-2022, 10:08 PM
Last Post: dangermaus33
  Confidence interval after doing penalised cox regression HatemAli 0 1,163 Feb-23-2022, 11:02 PM
Last Post: HatemAli
  split txt file data on the first column value shantanu97 2 2,480 Dec-29-2021, 05:03 PM
Last Post: DeaD_EyE
  Assigning a new value to variable uriel 1 1,636 Dec-04-2021, 02:59 PM
Last Post: Underscore
  Inconsistent counting / timing with threading rantwhy 1 1,789 Nov-24-2021, 04:04 AM
Last Post: deanhystad
  Retrieving a column from a data set using a function Bayle 6 2,408 Oct-06-2021, 08:52 PM
Last Post: Bayle

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020