How do you add the post-transformed pole to the originalram?



  • There's an original data fream:

    NameNovemberDecemberFebruary
    0Alexei.151015
    1Alexei.101010
    2AndreiEmptyEmptyEmpty
    3Andrei152515
    4Alexei.151510
    5Andrei251045

    For further change pd.drop Some lines were removed and a new column was received.

    Capital idx contains the original values of the indices:

    NameNovemberDecemberFebruarynumidx
    0Alexei.151015November0
    1Alexei.101010November1
    2Andrei152515February3
    3Alexei.151510November4
    4Andrei251045February5

    How am I supposed to add a new column to the original data framing?

    NameNovemberDecemberFebruarynum
    0Alexei.151015November
    1Alexei.101010November
    2AndreiEmptyEmptyEmpty
    3Andrei152515February
    4Alexei.151510November
    5Andrei251045February


  • Use the method. https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.join.html :

    res = df1.join(df2.set_index("idx")[["num"]])
    

    result:

    In [140]: res
    Out[140]:
          Name Ноябрь Декабрь Февраль      num
    0  Алексей     15      10      15   Ноябрь
    1  Алексей     10      10      10   Ноябрь
    2   Андрей  Empty   Empty   Empty      NaN
    3   Андрей     15      25      15  Февраль
    4  Алексей     15      15      10   Ноябрь
    5   Андрей     25      10      45  Февраль
    


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2