读取excel表格
读取excel表格
提问于 2021-10-22 21:22:54
将excel表格编码到R中的数据框中。我不想导出该表，我想将其编码为R中的数据框
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Period
1 0 0 0 0 0 0 0 0 0 0 0 1
0 1 0 0 0 0 0 0 0 0 0 0 2
0 0 1 0 0 0 0 0 0 0 0 0 3
0 0 0 1 0 0 0 0 0 0 0 0 4
0 0 0 0 1 0 0 0 0 0 0 0 5
0 0 0 0 0 1 0 0 0 0 0 0 6
0 0 0 0 0 0 1 0 0 0 0 0 7
0 0 0 0 0 0 0 1 0 0 0 0 8
0 0 0 0 0 0 0 0 1 0 0 0 9
0 0 0 0 0 0 0 0 0 1 0 0 10
0 0 0 0 0 0 0 0 0 0 1 0 11
0 0 0 0 0 0 0 0 0 0 0 1 12
1 0 0 0 0 0 0 0 0 0 0 0 13
0 1 0 0 0 0 0 0 0 0 0 0 14
0 0 1 0 0 0 0 0 0 0 0 0 15
0 0 0 1 0 0 0 0 0 0 0 0 16
0 0 0 0 1 0 0 0 0 0 0 0 17
0 0 0 0 0 1 0 0 0 0 0 0 18
0 0 0 0 0 0 1 0 0 0 0 0 19
0 0 0 0 0 0 0 1 0 0 0 0 20
0 0 0 0 0 0 0 0 1 0 0 0 21
0 0 0 0 0 0 0 0 0 1 0 0 22
0 0 0 0 0 0 0 0 0 0 1 0 23
0 0 0 0 0 0 0 0 0 0 0 1 24回答 2
Stack Overflow用户
发布于 2021-10-22 21:32:51
我认为你想要的是：
DF = read.table(text="Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Period
1 0 0 0 0 0 0 0 0 0 0 0 1
0 1 0 0 0 0 0 0 0 0 0 0 2
0 0 1 0 0 0 0 0 0 0 0 0 3
0 0 0 1 0 0 0 0 0 0 0 0 4
0 0 0 0 1 0 0 0 0 0 0 0 5
0 0 0 0 0 1 0 0 0 0 0 0 6
0 0 0 0 0 0 1 0 0 0 0 0 7
0 0 0 0 0 0 0 1 0 0 0 0 8
0 0 0 0 0 0 0 0 1 0 0 0 9
0 0 0 0 0 0 0 0 0 1 0 0 10
0 0 0 0 0 0 0 0 0 0 1 0 11
0 0 0 0 0 0 0 0 0 0 0 1 12
1 0 0 0 0 0 0 0 0 0 0 0 13
0 1 0 0 0 0 0 0 0 0 0 0 14
0 0 1 0 0 0 0 0 0 0 0 0 15
0 0 0 1 0 0 0 0 0 0 0 0 16
0 0 0 0 1 0 0 0 0 0 0 0 17
0 0 0 0 0 1 0 0 0 0 0 0 18
0 0 0 0 0 0 1 0 0 0 0 0 19
0 0 0 0 0 0 0 1 0 0 0 0 20
0 0 0 0 0 0 0 0 1 0 0 0 21
0 0 0 0 0 0 0 0 0 1 0 0 22
0 0 0 0 0 0 0 0 0 0 1 0 23
0 0 0 0 0 0 0 0 0 0 0 1 24",
header=T)Stack Overflow用户
发布于 2021-10-22 21:50:54
as.data.frame.matrix(table(1:24, factor(rep(month.abb, 2), month.abb)))
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1 1 0 0 0 0 0 0 0 0 0 0 0
2 0 1 0 0 0 0 0 0 0 0 0 0
3 0 0 1 0 0 0 0 0 0 0 0 0
4 0 0 0 1 0 0 0 0 0 0 0 0
5 0 0 0 0 1 0 0 0 0 0 0 0
6 0 0 0 0 0 1 0 0 0 0 0 0
7 0 0 0 0 0 0 1 0 0 0 0 0
8 0 0 0 0 0 0 0 1 0 0 0 0
9 0 0 0 0 0 0 0 0 1 0 0 0
10 0 0 0 0 0 0 0 0 0 1 0 0
11 0 0 0 0 0 0 0 0 0 0 1 0
12 0 0 0 0 0 0 0 0 0 0 0 1
13 1 0 0 0 0 0 0 0 0 0 0 0
14 0 1 0 0 0 0 0 0 0 0 0 0
15 0 0 1 0 0 0 0 0 0 0 0 0
16 0 0 0 1 0 0 0 0 0 0 0 0
17 0 0 0 0 1 0 0 0 0 0 0 0
18 0 0 0 0 0 1 0 0 0 0 0 0
19 0 0 0 0 0 0 1 0 0 0 0 0
20 0 0 0 0 0 0 0 1 0 0 0 0
21 0 0 0 0 0 0 0 0 1 0 0 0
22 0 0 0 0 0 0 0 0 0 1 0 0
23 0 0 0 0 0 0 0 0 0 0 1 0
24 0 0 0 0 0 0 0 0 0 0 0 1页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/69683203
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号