下面为相应的脚本与执行结果,str()可以清晰地看清每个字段名,sqldf却出现乱码,求解,谢谢!
在R中的脚本为:
combasedata<-"com-base-data.xls"
basedata<-read.xlsx2(combasedata,1,Encoding="UTF8")
str(basedata)
sqldf("select * from basedata limit 2")#此语出现结果异常,不知为何只有字段名乱码,内容则不会,上面的str()函数结果却可以清晰地看清每个字段名。
结果:
> str(basedata)
'data.frame': 11456 obs. of 24 variables:
$ 物料号 : Factor w/ 8375 levels "000010","000012",..: 5926 5948 5936 5934 5931 5941 5927 5943 5942 5944 ...
$ 物料名 : Factor w/ 8306 levels "(400MLX2+280MLX1)X8屈臣氏蒸馏水促销装",..: 3788 3776 3787 3779 3791 3780 3789 3785 3783 3781 ...
$ 物料组 : Factor w/ 28 levels "半成品","包装米粉",..: 4 4 4 4 4 4 4 4 4 4 ...
$ 常用单位代码. : Factor w/ 14 levels "BAG","BOT","BOX",..: 3 3 3 3 3 3 3 3 3 3 ...
$ 常用单位 : Factor w/ 14 levels "EA","袋","吨",..: 12 12 12 12 12 12 12 12 12 12 ...
$ 最小单位代码 : Factor w/ 18 levels "BAG","BOT","BOX",..: 2 7 2 2 2 1 2 7 7 7 ...
$ 最小单位 : Factor w/ 18 levels "EA","包","袋",..: 12 1 12 12 12 3 12 1 1 1 ...
$ 货主代码 : Factor w/ 66 levels "CQSW","CXLE",..: 1 1 1 1 1 1 1 1 1 1 ...
$ 货主名 : Factor w/ 66 levels "昌盛鸿笙食品",..: 3 3 3 3 3 3 3 3 3 3 ...
$ 业务范围 : Factor w/ 5 levels "城配","集团内",..: 1 1 1 1 1 1 1 1 1 1 ...
$ 保质期天. : Factor w/ 39 levels "","0","10000",..: 30 21 30 21 21 21 30 21 21 21 ...
$ 常用单位重量KG : Factor w/ 836 levels "0.006","0.0075",..: 175 168 175 265 265 261 175 656 656 656 ...
$ 常用单位体积CM3: Factor w/ 2241 levels "0","0.001669",..: 716 1302 716 1390 1390 1075 716 1388 1388 1388 ...
$ 常用转最小比率 : Factor w/ 457 levels "0.00526315789473684",..: 46 6 46 444 444 88 46 288 288 288 ...
$ 仓库 : Factor w/ 4 levels "","W155","WHGZ01",..: 1 1 1 1 1 1 3 1 1 1 ...
$ 库位 : Factor w/ 1 level "": 1 1 1 1 1 1 1 1 1 1 ...
$ 板数 : Factor w/ 10 levels "","0","1","100",..: 1 1 1 1 1 1 2 1 1 1 ...
$ 分类 : Factor w/ 7 levels "","0","A","B",..: 1 1 1 1 1 1 1 1 1 1 ...
$ 参考单位 : Factor w/ 6 levels "","BAG","BOT",..: 4 4 4 4 4 4 4 4 4 4 ...
$ 安全库存 : Factor w/ 8 levels "","0","180","200",..: 1 1 1 1 1 1 2 1 1 1 ...
$ 最大库存 : Factor w/ 8 levels "","0","100","120",..: 1 1 1 1 1 1 2 1 1 1 ...
$ 直发数 : Factor w/ 7 levels "","0","100","32",..: 1 1 1 1 1 1 2 1 1 1 ...
$ 条码 : Factor w/ 3700 levels ""," ","0","0000000000000",..: 2124 2148 2133 2132 2129 2138 2125 2140 2139 2141 ...
$ Encoding : Factor w/ 1 level "UTF8": 1 1 1 1 1 1 1 1 1 1 ...
> sqldf("select * from basedata limit 2")
Loading required package: tcltk
鐗╂枡鍙<b7> 鐗╂枡鍚<8d> 鐗╂枡缁<84> 甯哥敤鍗曚綅浠g爜.
1 cq6937428500055 精力沛牌全价麦胚芽(加卵磷脂)N(425g*12) 产品 BOX
2 cq6937428502318yc 精力沛牌高纤黑麦盒装(980g*10) 产品 BOX
甯哥敤鍗曚綅 鏈
附件列表