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 object jmf08 5 121 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 96 Jan-10-2019, 08:53 PM
Last Post: derwinduran
  New df from existing when condition occurs Devilish 0 98 Jan-10-2019, 12:03 AM
Last Post: Devilish
  How to remove whitespace from a string when .replace and .strip do not work winnetrie 7 137 Jan-05-2019, 08:44 AM
Last Post: DeaD_EyE
  Count of unique items based on condition JP_ROMANO 3 136 Dec-31-2018, 08:11 PM
Last Post: JP_ROMANO
  Remove CSV header Truman 9 342 Dec-26-2018, 11:39 PM
Last Post: Gribouillis
  Value , if condition mitmoot 6 147 Dec-07-2018, 06:41 PM
Last Post: nilamo
  Print data in rows and columns rlinux57 5 239 Nov-10-2018, 05:50 AM
Last Post: rlinux57
  Searching through a list of dictionaries with a condition. Mr_Keystrokes 11 524 Oct-05-2018, 11:03 AM
Last Post: Mr_Keystrokes
  Get New List Based on Dictionary Key leoahum 4 278 Oct-03-2018, 02:09 PM
Last Post: leoahum

Forum Jump:


Users browsing this thread: 1 Guest(s)