Python Forum
Merging two Data Frame on a special case
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Merging two Data Frame on a special case
#1
Hello everyone,

I have two data Frame one with date and one with product

df_A = date1, date2, date3............
df B = P1, P2, P3

All I need to create a data frame where there is product (P1, P2.....) for all the date in df A

Like the following
dfC = {date1: P1, date 2:P1, date3:P1......................date1: P3, date2:P3, date3:P3}

I know that I can use a for loop to do the same, but my data set is humongous and it takes almost 10 hrs to complete the loop. Is there an alternative faster way where I can create the same.

Thanks,
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  how do you style data frame that has empty rows. gsaray101 0 538 Sep-08-2023, 05:20 PM
Last Post: gsaray101
  googletrans library to translate text language for using data frame is not running gcozba2023 0 1,237 Mar-06-2023, 09:50 AM
Last Post: gcozba2023
  Load multiple Jason data in one Data Frame vijays3 6 1,565 Aug-12-2022, 05:17 PM
Last Post: vijays3
  conditionals based on data frame mbrown009 1 905 Aug-12-2022, 08:18 AM
Last Post: Larz60+
  Save data frame to .csv df.to.csv() mcva 1 1,547 Feb-03-2022, 07:05 PM
Last Post: mcva
  Switch case or match case? Frankduc 9 4,559 Jan-20-2022, 01:56 PM
Last Post: Frankduc
  Move a particular row in pandas data frame to last row klllmmm 0 3,780 Dec-27-2021, 09:11 AM
Last Post: klllmmm
  Iterating Through Data Frame Rows JoeDainton123 2 2,949 Aug-09-2021, 07:01 AM
Last Post: Pedroski55
  Filtering a data frame according to number of occurences of an observation Menthix 1 1,890 May-31-2021, 10:50 PM
Last Post: supuflounder
  get year information from a timestamp data frame asli 1 1,683 Jan-08-2021, 09:11 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

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