请教大神用R读取CSV时的问题

4关注
0粉丝

本科生

29%

还不是VIP/贵宾

-

0%

威望: 0 级
论坛币: 2517 个
通用积分: 0.7500
学术水平: 0 点
热心指数: 0 点
信用等级: 0 点
经验: 1820 点
帖子: 77
精华: 0
在线时间: 81 小时
注册时间: 2017-7-11
最后登录: 2024-3-31

楼主

Cnstopit 发表于 2017-8-1 23:23:02 |AI写论文

是否 +2 论坛币

k人参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

本人小白，读取CSV数据时，在excel里看，数据框架一样的数据，但是列却不一样。这是为什么
> names(data)
[1] "PERMNO"          "date"          "SICCD"          "TICKER"
[5] "COMNAM"          "NAICS"          "PERMCO"          "CUSIP"
[9] "NWPERM"          "PRC"             "VOL"             "BID"
[13] "ASK"             "SHROUT"          "VE"             "D"
[17] "rating"          "secid"          "cusip"          "optionid"
[21] "ticker"          "date.1"          "exdate"          "cp_flag"
[25] "open_interest" "impl_volatility"  "delta"          "gamma"
[29] "vega"          "theta"          "maturity"       "secid.1"
[33] "date.2"          "days"          "volatility"    "cusip.1"
[37] "ticker.1"       "sic"             "index_flag"    "exchange_d"
[41] "class"          "issue_type"    "industry_group" "futvol"
[45] "date.3"          "ticker.2"       "ccy"             "spread1y"
[49] "spread3y"       "spread5y"       "spread7y"       "spread10y"
[53] "compositedepth5y" "sector"          "recovery"       "docclause"
[57] "tier"          "rate"          "pd5"             "civ"
[61] "value"          "X"
> mydata=read.table("E:/CDS dissertation/cds initial/stock 7/stock.1.csv",sep=",",header=T, stringsAsFactors=F)
> names(mydata)
[1] "PERMNO"          "date"          "SICCD"          "TICKER"
[5] "COMNAM"          "NAICS"          "PERMCO"          "CUSIP"
[9] "NWPERM"          "PRC"             "VOL"             "BID"
[13] "ASK"             "SHROUT"          "VE"             "D"
[17] "rating"          "secid"          "cusip"          "optionid"
[21] "ticker"          "date.1"          "exdate"          "cp_flag"
[25] "open_interest" "impl_volatility"  "delta"          "gamma"
[29] "vega"          "theta"          "maturity"       "secid.1"
[33] "date.2"          "days"          "volatility"    "cusip.1"
[37] "ticker.1"       "sic"             "index_flag"    "exchange_d"
[41] "class"          "issue_type"    "industry_group" "futvol"
[45] "date.3"          "ticker.2"       "ccy"             "spread1y"
[49] "spread3y"       "spread5y"       "spread7y"       "spread10y"
[53] "compositedepth5y" "sector"          "recovery"       "docclause"
[57] "tier"          "rate"          "pd5"             "civ"
[61] "value"
>

####第一个data会比第二个mydata 数据多出一个“x”

然后我用RBIND时，多出“x”的CSV表格就会因为列数不一致而无法进行合并，请问如何解决？