Can someone suggest any python script or any script so that I can make modification in my excel sheets or text file ?

Question

[sahilbioinf0]

Like I have four columns in excel A,B,C,&D. The elements in D says Yes or No. If we make any code like it detect Yes in D column will automatically transform or interchange element in C to D without disturbing the No column elements. I have to change all yes elements in D like as described above. Please help me to do that!

[Mensur Dlakic]

This is trivial to do in Excel. Generally speaking, python scripts are not the best choice when it comes to manipulating Excel files, even though it can be done.

By the way, how is this related to bioinformatics?

[sahilbioinf0]

Thanks for the info. I have gfff3 file where the gene position (start and end) was incorrectly placed for some genes I want to make it correct using excel or as text file if condition met. I am reading about swap function in excel but was not able to do now ? I am trying though!

[sahilbioinf0]

I have done it using macros thanks for all the suggestions.

Answer 1

[swbarnes2]

No one wants to do your homework. Show what you tried, and someone might be able to give you a quick tweak that would work.

Honestly, I bet you could do this in Excel with an 'if' formula.

[sahilbioinf0]

Honestly, I am trying but not able to do that, information in cell B and C are large. If you know in excel if statement please suggest.

[Mensur Dlakic]

It is a simple IF-THEN-ELSE statement. Here are Google search results that should help you.

[sahilbioinf0]

I have done it using macros thanks for all the suggestions.

[sahilbioinf0]

B C D 12 14 Yes # If yes then change B to 14 and then C value to 12.