Hi Everyone,
I have a dataset something like:
A_count B_count S_count.......Z_count A_percentage B_percentage S_percentage............Z_percentage
------------------------------------------------------------------------------------------------------------------------------------------------------------
x x x x (xx.xx%) (xx.xx%) (xx.xx%) (xx.xx%)
and i want to do some thing like
finalA finalB finalS ...........finalZ
------------------------------------------------------------------------------------------------------------------------------------------------------------
x(xx.xx%) x(xx.xx%) x(xx.xx%) x (xx.xx%)
I'm trying to do this using foreach loop where i have a problem while joining the x[which is the count] with (xx.xx%)[percentages] which looks like concatenation but i have so many categories like A,C,S....Z that making it very cumbersome also to use a order function to get the final A, final B....final Z as i require in my output.
If, any suggestions how it can be handled, please do share your comments ? Not asking particularly to write a code for me, but even if you share ideas to solve which can help me to take this to a final level, That would be sufficient .Hope I'm clear. Your comments would be a great learning for me guys!
I have a dataset something like:
A_count B_count S_count.......Z_count A_percentage B_percentage S_percentage............Z_percentage
------------------------------------------------------------------------------------------------------------------------------------------------------------
x x x x (xx.xx%) (xx.xx%) (xx.xx%) (xx.xx%)
and i want to do some thing like
finalA finalB finalS ...........finalZ
------------------------------------------------------------------------------------------------------------------------------------------------------------
x(xx.xx%) x(xx.xx%) x(xx.xx%) x (xx.xx%)
I'm trying to do this using foreach loop where i have a problem while joining the x[which is the count] with (xx.xx%)[percentages] which looks like concatenation but i have so many categories like A,C,S....Z that making it very cumbersome also to use a order function to get the final A, final B....final Z as i require in my output.
If, any suggestions how it can be handled, please do share your comments ? Not asking particularly to write a code for me, but even if you share ideas to solve which can help me to take this to a final level, That would be sufficient .Hope I'm clear. Your comments would be a great learning for me guys!
Comment