Bottom Page

Thread Rating:
  • 3 Vote(s) - 2.33 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Remove Rows based on condition
#1
Hello,
I am totally new to python and not sure this is the correct place to ask a question.
I want to remove receipts which have opposite values (Y vs N,1 vs -1 etc.).if each receipt's row has opposite row. I.e. if also will be row 500.2 (with any content) - receipt 500 will not be removed.
Does any suggest me the best way to do with python script? I am a power bi developer and power bi accept python script.
Please see below link for data set and expected result.

<a href="http://tinypic.com?ref=2w1w9d4" target="_blank"><img src="http://i67.tinypic.com/2w1w9d4.png" border="0" alt="Image and video hosting by TinyPic"></a>

İmage
Quote
#2
for your post, you need to provide:
  • What you have tried so far (show best attempt code)
  • where the data is coming from, and how it's being displayed
  • Your operating system, python version and what packages are being used.
  • Anything else needed to duplicate starting point
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  How to convert rows to columns. jarrod0987 1 65 May-15-2019, 02:58 AM
Last Post: scidam
  Selecting a sample based on index Scott 1 66 May-14-2019, 08:44 AM
Last Post: Serferi
  Reg Xpression to remove a text stahorse 2 54 May-14-2019, 05:58 AM
Last Post: stahorse
  Condition check differences and how to organise code? adam2020 4 144 May-12-2019, 04:12 PM
Last Post: Yoriz
  zip lists with condition 3Pinter 6 104 May-09-2019, 05:16 PM
Last Post: DeaD_EyE
  How to remove space between strings sunnyarora 2 71 May-03-2019, 11:44 AM
Last Post: perfringo
  Remove Email Signature NewBeie 3 107 Apr-29-2019, 11:52 AM
Last Post: Larz60+
  csv to xlsx, remove " while writing to excel anna 3 151 Apr-16-2019, 07:57 AM
Last Post: anna
  How to add new rows to existing csv file Sri 1 111 Apr-08-2019, 05:49 PM
Last Post: Larz60+
  remove string character from url jacklee26 10 422 Mar-25-2019, 03:56 PM
Last Post: Larz60+

Forum Jump:


Users browsing this thread: 1 Guest(s)