[datatable-help] subset between data.table list and single data.table object

iembry iruckaE at mail2world.com
Thu Aug 8 18:46:48 CEST 2013


I'm sorry, but the previous .html page was only a .txt page so I'm replacing
it here: inputoutput.html
<http://r.789695.n4.nabble.com/file/n4673378/inputoutput.html>  I have also
included the preformatted text below.Irucka
INPUTbig            y		x              	site_no     1: 14.80    	7900 	
/tried/02437100.exsa.rdb     2: 14.81    	7920 		/tried/02437100.exsa.rdb    
3: 14.82    	7930 		/tried/02437100.exsa.rdb     4: 14.83    	7950 	
/tried/02437100.exsa.rdb     5: 14.84    	7970 		/tried/02437100.exsa.rdb   
---                                                 112249: 57.86 		2400000 
/tried/07289000.exsa.rdb112250: 57.87 		2410000 
/tried/07289000.exsa.rdb112251: 57.88 		2410000 
/tried/07289000.exsa.rdb112252: 57.89 		2420000 
/tried/07289000.exsa.rdb112253: 57.90 		2430000 
/tried/07289000.exsa.rdbaimjoin     site_no      	mean      	p50 1: 02437100   	
3882.65   	1830.0 2: 02446500    	819.82    	382.0 3: 02467000  		23742.37  
10400.0 4: 03217500    	224.72     	50.0 5: 03219500    	496.79    	140.0 
---  54: 06889000   		5632.70   	2620.055: 06891000   		7018.45   	3300.056:
06893000  		52604.19  	43200.057: 06934500  		81758.03  	61200.058: 07010000 	
186504.25 	147000.059: 07289000 		755685.30 	687000.0     site_no      	mean      
p50INTERMEDIATEbigintermediate            y		x              	site_no		mean      
p50     1: 14.80    	7900 		02437100	3882.65   	1830.0     2: 14.81    	7920 	
02437100	3882.65   	1830.0     3: 14.82    	7930 		02437100	3882.65   
1830.0     4: 14.83    	7950 		02437100	3882.65   	1830.0     5: 14.84    
7970 		02437100	3882.65   	1830.0    ---                                                
112249: 57.86 		2400000 	07289000	755685.30	687000.0112250: 57.87 		2410000 
07289000	755685.30	687000.0112251: 57.88 		2410000 	07289000	755685.30
687000.0112252: 57.89 		2420000 	07289000	755685.30	687000.0112253: 57.90 	
2430000 	07289000	755685.30	687000.0OUTPUTbigintermean [where mean of
site_no > min(x)]            y       	x               site_no		mean        
---        ...   112249: 57.86 		2400000 	07289000	755685.30112250: 57.87 	
2410000 	07289000	755685.30112251: 57.88 		2410000 	07289000
755685.30112252: 57.89 		2420000 	07289000	755685.30112253: 57.90 		2430000 
07289000	755685.30total of 109,452 rowsbigintermedian [where p50 of site_no
> min(x)]            y       	x               site_no		p50    ---        ...  
112249: 57.86 		2400000 	07289000	687000.0112250: 57.87 		2410000 	07289000
687000.0112251: 57.88 		2410000 	07289000	687000.0112252: 57.89 		2420000 
07289000	687000.0112253: 57.90 		2430000 	07289000	687000.0total of 109,452
rowsbigextramean [where mean of site_no < min(x)]            y		x              
site_no		mean         1: 14.80    	7900 		02437100	3882.65      2: 14.81    
7920 		02437100	3882.65       3: 14.82    	7930 		02437100	3882.65       4:
14.83    	7950 		02437100	3882.65      5: 14.84    	7970 		02437100
3882.65total of 2671 rowsbigextramedian [where p50 of site_no < min(x)]           
y		x              	site_no		p50     1: 14.80    	7900 		02437100	1830.0    
2: 14.81    	7920 		02437100	1830.0     3: 14.82    	7930 		02437100	1830.0    
4: 14.83    	7950 		02437100	1830.0     5: 14.84    	7970 		02437100
1830.0total of 2671 rowsbigextrameanmax [where mean of site_no > max(x)]           
y		x              	site_no		mean         1: 14.80    	7900 		02437100
3882.65      2: 14.81    	7920 		02437100	3882.65       3: 14.82    	7930 	
02437100	3882.65       4: 14.83    	7950 		02437100	3882.65      5: 14.84    
7970 		02437100	3882.65total of 2671 rowsbigextramedianmax [where p50 of
site_no > max(x)]            y		x              	site_no		p50     1: 14.80    
7900 		02437100	1830.0     2: 14.81    	7920 		02437100	1830.0     3: 14.82    
7930 		02437100	1830.0     4: 14.83    	7950 		02437100	1830.0     5: 14.84    
7970 		02437100	1830.0total of 2671 rows




--
View this message in context: http://r.789695.n4.nabble.com/subset-between-data-table-list-and-single-data-table-object-tp4673202p4673378.html
Sent from the datatable-help mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/datatable-help/attachments/20130808/b6c665f5/attachment-0001.html>


More information about the datatable-help mailing list