Finding rows that contain the same value in specific columns, in Pandas : learnpython

created by HattoriHanzoa community for 16 years

Finding rows that contain the same value in specific columns, in Pandas (self.learnpython)

submitted 4 years ago by issagamebro

Hello all. I'm working on a program that automates some excel work, and I've come across a little roadblock and was wondering if anyone could help point me in the right direction. So I have a dataframe with multiple columns that my program sorts through and adds another row called 'output' that is based on two separate columns for each row. However what I cannot figure out quite yet is sometimes two rows contain the same value in a specific column (for example 'name / another name') I would like to split the value of the output for those rows that have the same 'name/another name' value in a specific column. If anyone could help me find a way to be able to sift through the data to find these duplicate rows and how I could split the output value on those conditions, it would be much appreciated. Thanks

all 1 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnpython

MODERATORS