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
#2
What have you tried? Show us and we will be able to help you
pyzyx3qwerty
"The greatest glory in living lies not in never falling, but in rising every time we fall." - Nelson Mandela
Need help on the forum? Visit help @ python forum
For learning more and more about python, visit Python docs
Reply


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