Hi, I have a specific problem that doesn't seem to be all that common. I have a data set with ~90 values, that have two characteristics: "Intensity", and "MeV". MeV, though a number, should only be used as an identifier string.
"Intensity" is a decimal value that is only relative to other "Intensity". I want to:
>Add up all the values of "Intensity"
>Determine the percentage of each unique value of Intensity relative to the total, and list it, identified by it's unique MeV string.
For example, if my table looks like this:
I want an output of:
This seems like it should be trivial to do, but it doesn't seem to come up as a problem too much, at least in this format. Any help would be appreciated! Thanks.