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
  remove string character from url jacklee26 8 164 4 hours ago
Last Post: Larz60+
  SOAP based webservice invoke mehrdadabedi 1 53 Mar-10-2019, 06:04 PM
Last Post: mlieqo
  How to ger matching rows data based on index columns SriRajesh 1 70 Mar-08-2019, 11:05 AM
Last Post: scidam
  script: remove all "carriage return" from my json variable mfran2002 4 173 Feb-20-2019, 05:07 AM
Last Post: mfran2002
  Comparing the count of rows from the tables that are present in two different databas krt5 6 145 Feb-15-2019, 03:20 PM
Last Post: krt5
  Selection based of variables issue nikos 14 635 Feb-09-2019, 08:23 AM
Last Post: nikos
  column order changes when copying rows in datafram swapnaharish 1 90 Feb-07-2019, 11:52 AM
Last Post: scidam
  Merge rows of 2 arrays vipinv23 2 156 Jan-27-2019, 05:45 PM
Last Post: aakashjha001
  Remove object jmf08 5 208 Jan-17-2019, 02:01 PM
Last Post: ichabod801
  Get the info from 2 different rows in the same column using a one key derwinduran 0 167 Jan-10-2019, 08:53 PM
Last Post: derwinduran

Forum Jump:


Users browsing this thread: 1 Guest(s)