Conditionally merge columns using Pandas
I start out with this pandas dataframe:
sampleID scaffoldID Type Program Breadth \
3 G38791 scaffold_7 4 A 73.558964
0 G38791 scaffold_388 3 B 0.000000
1 G38791 scaffold_777 2 B 0.000000
2 G38791 scaffold_787 0 B 0.000000
3 G38791 scaffold_7 4 B 73.558964
How can I conditionally merge columns? So if df['Type' ==4], I want to change Type value for that row to "Partial" then merge column value at Program and Breadth value to give a new value for the column, Type to partial_A_73.558964?
New dataframe should be:
sampleID scaffoldID Type Program Breadth \
3 G38791 scaffold_7 partial_A_73.558964 A 73.558964
0 G38791 scaffold_388 3 B 0.000000
1 G38791 scaffold_777 2 B 0.000000
2 G38791 scaffold_787 0 B 0.000000
3 G38791 scaffold_7 partial_B_73.558964 B 73.558964
1 answer
I will be dropping both Program and Breadth column which is why I needed to concat the rows. I agree with you that in general you should not mix data types but, because of the analysis I will be conducting the Type column tell us a lot about the row, especially those that are partials.
Log in to answer this question.
More posts like this
-
Tutorial: Bulk RNA-seq: Different Expression Analysis
written by Julia Ma •
-
how to loop and select values from a python dataframe
written by raalsuwaidi •
-
calculating fold change from dataframe
written by Gil Rodriguez •
-
plots of genomic annotations together with fictitious RNA binding protein data with python
written by Jakpa •
-
For Loop to make new dataframe
written by selplat21 •
-
How to interpret DESeq2 result?
written by helen •
-
Matching date and condition from different dataframe to get specific score
written by hoc307 •
-
Merging data coloum wise in R
written by David_emir
-
R: compare 1 columns from two matrices and get the output if they are the same
written by IrK
-
Setting elementMetadata in genomicranges list objects
written by reviewer3 •
