Difference between revisions of "INTERA:Formaldehyde concentrations in Europe"

From Testiwiki
Jump to: navigation, search
m (Result: link added)
m (Formula)
Line 17: Line 17:
 
=== Formula ===
 
=== Formula ===
  
<rcode>
+
Code used for reading and transforming the source csv file can be found on [http://en.opasnet.org/en-opwiki/index.php?title=INTERA:Formaldehyde_concentrations_in_Europe&oldid=19551 an earlier version of this page].
form <- read.table("M:/Intera_data/Formaldehyde_EU.csv", header = TRUE, sep = ";", dec = ",", strip.white = TRUE, fill = TRUE) #.csv based on excel
 
temp1 <- reshape(form[-(1:nrow(form))[duplicated(form[,1:5])],], idvar = c("Country", "City", "Year", "Environment", "Environment_spec"),
 
times = colnames(form)[6:ncol(form)], timevar = "Parameter", varying =
 
list(colnames(form)[6:ncol(form)]), direction = "long") #reshaped from 2d value representation to 1d
 
temp2 <- reshape(form[(1:nrow(form))[duplicated(form[,1:5])],], idvar = c("Country", "City", "Year", "Environment", "Environment_spec"),
 
times = colnames(form)[6:ncol(form)], timevar = "Parameter", varying =
 
list(colnames(form)[6:ncol(form)]), direction = "long") #resh
 
form <- rbind(temp1,temp2)
 
colnames(form)[7] <- "Result"
 
form[is.na(form$Result),"Result"] <- ""
 
form[form$Result=="","Result"] <- NA
 
form[form$Environment_spec=="bedroom", "Environment_spec"] <- "Bedroom"
 
form[form$Environment_spec=="living room", "Environment_spec"] <- "Living room"
 
form[form$Environment_spec=="new dwellings", "Environment_spec"] <- "New dwellings"
 
#library(OpasnetBaseUtils)
 
#op_baseWrite("opasnet_base", form, ident = "Op_en5062", acttype = 4, unit = "ugm^-3")
 
</rcode>
 
  
 
== Result ==
 
== Result ==

Revision as of 07:16, 14 April 2011


Scope

The Formaldehyde concentrations in indoor, outdoor and personal measurements in several European countries.

Definition

Data

Data is obtained from various studies (like Expolis). Refs are added later.

Dependencies

Unit

ugm^-3

Formula

Code used for reading and transforming the source csv file can be found on an earlier version of this page.

Result

Show results


See also

Keywords

References


Related files

<mfanonymousfilelist></mfanonymousfilelist>

INTERA:Formaldehyde concentrations in Europe. Opasnet . [1]. Accessed 26 Jun 2024.