How to combine data measured in different unitsI have a JMP Table that contains data measured hourly at about 50 different stations. At each station the data is sometimes reported in ppm, other times in ppb, occasionally in both units and occasionally, there are no measurements at all. It's a pretty large dataset and I'm wondering - how do I automate combining the columns that pertain to each station into a single column in one system of units. Or do I have to manually create a new column for each station and enter a formula to do the conversion? I'm just trying to speed up this data prep step without using Excel.
Data TableRe: How to combine data measured in different unitsA very simple script can be used to change the values directly in the column it came in. Or you can use the Recode tool to do the same, in an interactive format. How do you determine what the units of measurement are? Is there a separate column that indicates that?
Re: How to combine data measured in different unitsDoes the data appear as numeric (without the units - or units in a separate field) or as character data where the units appear with the number (e.g., 13ppm)? It would be easier if you can provide an example of how the data appears. A formula should make the conversion you want, but exactly what formula depends on what the data looks like.
Re: How to combine data measured in different units
Re: How to combine data measured in different unitsHi,
This is what the data looks like. The column name says the station and the units for the measurement.
Thank you kindly for the help.
Re: How to combine data measured in different unitsHi Jim,
I posted a picture of that the data looks like, in answer to your question. Please tell me the steps to change the data in place.
Thank you.
