Python Forum
update column in one data frame with value of column from another data frame
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
update column in one data frame with value of column from another data frame
#1
Hi there

In Python 3.7 , I need some help with the syntax of updating data frame with value from another data frame:

I have a trade and it has 2 rows - one for the start and one for the end

I would like to update the start time in end row.

for example - df_start (start trades) and df_end (end trades) - the column position_id is identical between the tow (this column is the key for the 2 data frames)

I need the column time in df_end to change like that : df_end['time'] = df_start['time']



Thanks for the help :)
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Camelot not able to change column header shortmeister1 2 658 Mar-22-2025, 04:47 AM
Last Post: Pedroski55
  Don't update/upload null data Philskidvd 0 579 Mar-20-2025, 10:52 AM
Last Post: Philskidvd
  Transform 3 Columns into Single Column DaveG 9 3,454 Mar-19-2025, 03:46 AM
Last Post: robbert23
  renaming a column without a name in a dataframe Carbonpony 2 750 Jan-23-2025, 08:20 AM
Last Post: Carbonpony
  Python: How to import data from txt, instead of running the data from the code? Melcu54 1 597 Dec-13-2024, 06:50 AM
Last Post: Gribouillis
  Updating column name with translation bobbydave 0 1,046 Sep-17-2024, 03:40 PM
Last Post: bobbydave
  adding a calculated column charles986 1 859 Jun-13-2024, 05:31 PM
Last Post: deanhystad
  adding a calculated column charles986 1 669 Jun-13-2024, 02:27 PM
Last Post: deanhystad
  Help with to check an Input list data with a data read from an external source sacharyya 3 1,616 Mar-09-2024, 12:33 PM
Last Post: Pedroski55
  Adding PD DataFrame column bsben 2 1,274 Mar-08-2024, 10:46 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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