[R] how to import a dataframe with mixed text and numbers

Felipe Carrillo mazatlanmexico at yahoo.com
Sat Apr 24 21:11:04 CEST 2010


Hi:
I need help with a dataframe. is a mix of dates and text.
I want to create a table either using latex function from hmisc or xtable. I
already know how to do this but the problem is getting the dataframe into R.
I don't have a reproducible example . If someone is interested in 
helping with this task I could
send the excel file offlist. Thanks


Date                              First                   Second                       Third 
2/26/2010 --------------------0 ( − ) ----------------------0 ( − ) ------------------7,002 (33 − 39) 
2/27/2010-------------------- n (0 − 0) ------------------n (0 − 0)--------------- n (0 − 0) 
2/28/2010------------------- 357 (123 − 123)---------0 ( − )------------------- 130,342 (29 − 57) 
3/1/2010 --------------------144 (95 − 152)-------------99 (65 − 71)-------- 22,741 (31 − 56) 
3/2/2010 -------------------73 (126 − 152)--------------- 0 ( − ) ----------------8,365 (31 − 53) 
3/3/2010 -------------------43 (108 − 108)--------------- 86 (66 − 76) --------5,962 (33 − 60) 
3/4/2010------------------- n (0 − 0) -----------------------n (0 − 0)---------------- n (0 − 0) 
3/5/2010 ------------------270 (101 − 140)-------------- 0 ( − ) -----------------22,461 (30 − 61) 
3/6/2010 ------------------121 (111 − 112)--------------- 40 (66 − 66)--------- 12,485 (31 − 55) 
3/7/2010 -----------------------0 ( − ) -----------------------0 ( − ) -------------------7,352 (31 − 56) 
3/8/2010 --------------------34 (111 − 111)-------------- 33 (74 − 74)------------ 2,908 (32 − 48) 
Biweekly Lower 90% Confidence Interval ------------   -537--------- -549 -------------35,097 
Biweekly Total -------------1,425 ----------------------------402 -----------------------------296,085 
Biweekly Upper 90% Confidence Interval ----------3,388 --------------1,353 -------------557,074 
Brood-year  Lower 90% Confidence Interval ---------------2,578,499 ---------------74,306 ------------2,249,920 
Brood Year Total ----------4,455,877------------------------ 314,206 -----------------------7,347,719 
Brood-year Upper 90% Confidence Interval ---------------6,333,255 --------------541,552 ----------------12,058,021 

 
Felipe D. Carrillo
Supervisory Fishery Biologist
Department of the Interior
US Fish & Wildlife Service
California, USA






More information about the R-help mailing list