完整程序

options(repos = "http://mirrors.tuna.tsinghua.edu.cn/CRAN/")

install.packages('readxl')
install.packages('dplyr')
install.packages('reshape')

package 'readxl' successfully unpacked and MD5 sums checked

The downloaded binary packages are in
    C:\Users\23947\AppData\Local\Temp\Rtmp42LzAJ\downloaded_packages
package 'dplyr' successfully unpacked and MD5 sums checked

The downloaded binary packages are in
    C:\Users\23947\AppData\Local\Temp\Rtmp42LzAJ\downloaded_packages


also installing the dependency 'plyr'



package 'plyr' successfully unpacked and MD5 sums checked
package 'reshape' successfully unpacked and MD5 sums checked

The downloaded binary packages are in
    C:\Users\23947\AppData\Local\Temp\Rtmp42LzAJ\downloaded_packages

library(readxl)
library(dplyr)
library(reshape)

Warning message:
"package 'readxl' was built under R version 3.3.3"Warning message:
"package 'dplyr' was built under R version 3.3.3"
Attaching package: 'dplyr'

The following objects are masked from 'package:stats':

    filter, lag

The following objects are masked from 'package:base':

    intersect, setdiff, setequal, union

Warning message:
"package 'reshape' was built under R version 3.3.3"
Attaching package: 'reshape'

The following object is masked from 'package:dplyr':

    rename

data=read_excel("data_2.xlsx",sheet = 2)

transe=function(x){
   x=log(x+1)}

c=transe(10)

data

CODE	year	ONLINE_REAL	PRE_TREATE_TIME	TIME_STAP	AFTER_TREATE_TIME	IPO	SIG	MIN_DRIVING	NUM_EP	ROE	ROA	ZCZJ	LN_MIN	LN_NUM	LN_ZCZJ
000001.SZ	0	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1991-04-03	0	4767	12525	17.64	0.0000	1.207000e+12	8.469682	9.435562	27.81916
000001.SZ	1	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1991-04-03	0	4767	13778	4.57	0.0000	1.368000e+12	8.469682	9.530901	27.94437
000002.SZ	0	12/1/2013	2013-09-30	2013-12-31	2014-03-31	1991-01-29	0	21118	31019	9.31	2.5779	4.611000e+11	9.957928	10.342387	26.85688
000002.SZ	1	12/1/2013	2013-09-30	2013-12-31	2014-03-31	1991-01-29	0	21118	35330	1.97	0.4563	4.951000e+11	9.957928	10.472516	26.92803
000004.SZ	0	9/1/2009	2009-06-30	2009-09-30	2009-12-31	1991-01-14	0	9579	288	-1.62	0.7268	1.708000e+08	9.167433	5.666427	18.95600
000004.SZ	1	9/1/2009	2009-06-30	2009-09-30	2009-12-31	1991-01-14	0	9579	291	3.96	4.0435	2.305000e+08	9.167433	5.676754	19.25576
000005.SZ	0	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1990-12-10	0	5171	671	1.97	2.1803	1.291000e+09	8.551015	6.510258	20.97868
000005.SZ	1	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1990-12-10	0	5171	501	-1.87	-0.4980	1.255000e+09	8.551015	6.218600	20.95040
000006.SZ	0	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1992-04-27	0	3802	276	10.62	5.0531	7.683000e+09	8.243546	5.624018	22.76228
000006.SZ	1	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1992-04-27	0	3802	283	2.77	1.4917	8.325000e+09	8.243546	5.648974	22.84253
000007.SZ	0	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1992-04-13	0	5623	751	0.00	1.9629	3.266000e+08	8.634798	6.622736	19.60425
000007.SZ	1	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1992-04-13	0	5623	675	0.18	0.4117	4.259000e+08	8.634798	6.516193	19.86972
000008.SZ	0	7/1/2004	2004-06-30	2004-09-30	2004-12-31	1992-05-07	0	11595	22	0.96	0.7088	6.323151e+07	9.358415	3.135494	17.96231
000008.SZ	1	7/1/2004	2004-06-30	2004-09-30	2004-12-31	1992-05-07	0	11595	26	77.40	53.7855	9.079773e+07	9.358415	3.295837	18.32414
000009.SZ	0	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1991-06-25	0	3228	5496	9.00	4.8616	1.126000e+10	8.079928	8.611958	23.14452
000009.SZ	1	12/1/2011	2011-09-30	2011-12-31	2012-03-31	1991-06-25	0	3228	5697	1.23	1.2082	1.205000e+10	8.079928	8.647871	23.21233
000010.SZ	0	9/1/2009	2009-06-30	2009-09-30	2009-12-31	1995-10-27	0	10149	22	15.47	4.7190	2.268000e+08	9.225229	3.135494	19.23958
000010.SZ	1	9/1/2009	2009-06-30	2009-09-30	2009-12-31	1995-10-27	0	10149	21	17.19	6.6259	2.319000e+08	9.225229	3.091042	19.26182
000011.SZ	0	12/1/2011	2011-09-30