Python Forum
Pandas - updating the original dataframe with sub selects
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pandas - updating the original dataframe with sub selects
#1
Hi

I have a dataframe with the follwoing columns
source	date	host	tag	adreq	adimpr	revenue	Device	deleteme
Now some of the rows have things I do not want to see, but I do not want to delete.
How do I update the dataframe.

I tried the following - but this gives a warning about updating a slice
tdf = self.dfDemands[ (self.dfDemands.deleteme == False) & (self.dfDemands.source == 'thesource') & (self.dfDemands.host == 'nameofahost') ]
tdf['deleteme'] = True
self.dfDemands.update( tdf )
Also tried
self.dfDemands['deleteme'] = (self.dfDemands.deleteme == False) & (self.dfDemands.source == 'Source') & (self.dfDemands.host == 'nameofahost')
Which although doesn't appear to error - doesn't up date either

Must be something simple... Any pointers please?

link to settingwithwarning
Nevermind, the link helped and I think it is working as required now :)
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Question [Solved] Formatting cells of a pandas dataframe into an OpenDocument ods spreadsheet Calab 1 497 Mar-01-2025, 04:51 AM
Last Post: Calab
  Find duplicates in a pandas dataframe list column on other rows Calab 2 1,925 Sep-18-2024, 07:38 PM
Last Post: Calab
  Find strings by index from a list of indexes in a different Pandas dataframe column Calab 3 1,540 Aug-26-2024, 04:52 PM
Last Post: Calab
  Add NER output to pandas dataframe dg3000 0 1,115 Apr-22-2024, 08:14 PM
Last Post: dg3000
  HTML Decoder pandas dataframe column mbrown009 3 2,571 Sep-29-2023, 05:56 PM
Last Post: deanhystad
  Use pandas to obtain cartesian product between a dataframe of int and equations? haihal 0 1,962 Jan-06-2023, 10:53 PM
Last Post: haihal
  Pandas Dataframe Filtering based on rows mvdlm 0 2,034 Apr-02-2022, 06:39 PM
Last Post: mvdlm
  Pandas dataframe: calculate metrics by year mcva 1 3,350 Mar-02-2022, 08:22 AM
Last Post: mcva
  Pandas dataframe comparing anto5 0 1,876 Jan-30-2022, 10:21 AM
Last Post: anto5
  PANDAS: DataFrame | Replace and others questions moduki1 2 2,579 Jan-10-2022, 07:19 PM
Last Post: moduki1

Forum Jump:

User Panel Messages

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