[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