the data file has such structure:
1992 6245 49 . . 20 1
0 0 8.739536 0 . . .
. . . . .
"alabama"
. 0 .
1993 7677 58 . . 15 1
0 0 8.945984 1 . 0 .2064476
-5 0 . 0 8.739536
"alabama"
9 0 0
1992 13327 57 36 58 16 0
0 0 9.497547 0 47 . .
. . . 0 .
"arizona"
. 0 .
1993 19860 57 36 58 16 1
1 0 9.896463 1 47 0 .3989162
0 1 0 1 9.497547
"arizona"
0 1 1
1992 10422 37 28 58 20 0
0 0 9.251675 0 43 . .
. . . -1 . "arizona
state"
. 0 .
------snip-----
the data descriptions is:
variable names:
year apps top25 ver500 mth500 stufac bowl btitle
finfour lapps d93 avg500 cfinfour clapps cstufac cbowl
cavg500 cbtitle lapps_1 school ctop25 bball cbball
Obs: 118
1. year 1992 or 1993
2. apps # applics for admission
3. top25 perc frosh class in 25th high sch percen
4. ver500 perc frosh >= 500 on verbal SAT
5. mth500 perc frosh >= 500 on math SAT
6. stufac student-faculty ratio
7. bowl = 1 if bowl game in prev year
8. btitle = 1 if men's cnf chmps prev year
9. finfour = 1 if men's final 4 prev year
10. lapps log(apps)
11. d93 =1 if year = 1993
12. avg500 (ver500+mth500)/2
13. cfinfour change in finfour
14. clapps change in lapps
15. cstufac change in stufac
16. cbowl change in bowl
17. cavg500 change in avg500
18. cbtitle change in btitle
19. lapps_1 lapps lagged
20. school university name
21. ctop25 change in top25
22. bball =1 if btitle or finfour
23. cbball change in bball
so the each four lines represent one case,can some variables are numeric and
some are character.
I though the scan can read it in ,but it seems somewhat tricky as the mixed type
of variables.any suggestions?
the attachmen is the raw data and the description of the data.
2005-10-15
------
Deparment of Sociology
Fudan University
My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com
It seems my last post not sent successfully ,so I post again.
-------------
the data file has such structure:
1992 6245 49 . . 20 1
0 0 8.739536 0 . . .
. . . . .
"alabama"
. 0 .
1993 7677 58 . . 15 1
0 0 8.945984 1 . 0 .2064476
-5 0 . 0 8.739536
"alabama"
9 0 0
1992 13327 57 36 58 16 0
0 0 9.497547 0 47 . .
. . . 0 .
"arizona"
. 0 .
1993 19860 57 36 58 16 1
1 0 9.896463 1 47 0 .3989162
0 1 0 1 9.497547
"arizona"
0 1 1
1992 10422 37 28 58 20 0
0 0 9.251675 0 43 . .
. . . -1 . "arizona
state"
. 0 .
------snip-----
the data descriptions is:
variable names:
year apps top25 ver500 mth500 stufac bowl btitle
finfour lapps d93 avg500 cfinfour clapps cstufac cbowl
cavg500 cbtitle lapps_1 school ctop25 bball cbball
Obs: 118
1. year 1992 or 1993
2. apps # applics for admission
3. top25 perc frosh class in 25th high sch percen
4. ver500 perc frosh >= 500 on verbal SAT
5. mth500 perc frosh >= 500 on math SAT
6. stufac student-faculty ratio
7. bowl = 1 if bowl game in prev year
8. btitle = 1 if men's cnf chmps prev year
9. finfour = 1 if men's final 4 prev year
10. lapps log(apps)
11. d93 =1 if year = 1993
12. avg500 (ver500+mth500)/2
13. cfinfour change in finfour
14. clapps change in lapps
15. cstufac change in stufac
16. cbowl change in bowl
17. cavg500 change in avg500
18. cbtitle change in btitle
19. lapps_1 lapps lagged
20. school university name
21. ctop25 change in top25
22. bball =1 if btitle or finfour
23. cbball change in bball
so the each four lines represent one case,can some variables are numeric and
some are character.
I though the scan can read it in ,but it seems somewhat tricky as the mixed type
of variables.any suggestions?
2005-10-15
------
Deparment of Sociology
Fudan University
My new mail addres is ronggui.huang at gmail.com
Blog:http://sociology.yculblog.com
Dear ronggui,
I didn't find any attachments, but using the data lines in your
message, and assuming that . represents missing data, the following
appears to do what you want:
as.data.frame(scan("c:/temp/ronggui.txt",
list(year=1, apps=1, top25=1, ver500=1,
mth500=1, stufac=1, bowl=1, btitle=1, finfour=1, lapps=1,
d93=1,
avg500=1, cfinfour=1, clapps=1, cstufac=1, cbowl=1, cavg500=1,
cbtitle=1, lapps_1=1, school="", ctop25=1, bball=1,
cbball=1,),
na.strings="."))
See ?scan for details.
I hope this helps,
John
On Sat, 15 Oct 2005 15:57:42 +0800
ronggui <042045003 at fudan.edu.cn> wrote:> the data file has such structure:
>
> 1992 6245 49 . . 20
> 1
> 0 0 8.739536 0 . .
> .
> . . . . .
> "alabama"
> . 0 .
> 1993 7677 58 . . 15
> 1
> 0 0 8.945984 1 . 0
> .2064476
> -5 0 . 0 8.739536
> "alabama"
> 9 0 0
> 1992 13327 57 36 58 16
> 0
> 0 0 9.497547 0 47 .
> .
> . . . 0 .
> "arizona"
> . 0 .
> 1993 19860 57 36 58 16
> 1
> 1 0 9.896463 1 47 0
> .3989162
> 0 1 0 1 9.497547
> "arizona"
> 0 1 1
> 1992 10422 37 28 58 20
> 0
> 0 0 9.251675 0 43 .
> .
> . . . -1 . "arizona
> state"
> . 0 .
>
> ------snip-----
>
> the data descriptions is:
>
> variable names:
>
> year apps top25 ver500 mth500 stufac bowl
> btitle
> finfour lapps d93 avg500 cfinfour clapps cstufac
> cbowl
> cavg500 cbtitle lapps_1 school ctop25 bball cbball
>
>
> Obs: 118
>
> 1. year 1992 or 1993
> 2. apps # applics for admission
> 3. top25 perc frosh class in 25th high sch
> percen
> 4. ver500 perc frosh >= 500 on verbal SAT
> 5. mth500 perc frosh >= 500 on math SAT
> 6. stufac student-faculty ratio
> 7. bowl = 1 if bowl game in prev year
> 8. btitle = 1 if men's cnf chmps prev year
> 9. finfour = 1 if men's final 4 prev year
> 10. lapps log(apps)
> 11. d93 =1 if year = 1993
> 12. avg500 (ver500+mth500)/2
> 13. cfinfour change in finfour
> 14. clapps change in lapps
> 15. cstufac change in stufac
> 16. cbowl change in bowl
> 17. cavg500 change in avg500
> 18. cbtitle change in btitle
> 19. lapps_1 lapps lagged
> 20. school university name
> 21. ctop25 change in top25
> 22. bball =1 if btitle or finfour
> 23. cbball change in bball
>
>
> so the each four lines represent one case,can some variables are
> numeric and some are character.
> I though the scan can read it in ,but it seems somewhat tricky as the
> mixed type of variables.any suggestions?
>
> the attachmen is the raw data and the description of the data.
>
>
> 2005-10-15
>
> ------
> Deparment of Sociology
> Fudan University
>
> My new mail addres is ronggui.huang at gmail.com
> Blog:http://sociology.yculblog.com
--------------------------------
John Fox
Department of Sociology
McMaster University
Hamilton, Ontario, Canada
http://socserv.mcmaster.ca/jfox/