Error in plot.window(xlim, ylim) : invalid 'xlim' value

General
1

while doing panel data analysis I am getting the following error. please help
thanks in advance

code

mydata<- read.csv("data_1.csv")

mydata$date <- dmy(mydata$date)

summary(mydata)

y <- mydata$return
x <- mydata$COVID19_new_cases

coplot(y ~ indices|date, type="l", data=mydata, xlim = c("2020-03-02","2020-04-30"),ylim = c(-0.16,0.10))

coplot(y ~ indices|date, type="b", data=mydata, xlim = c("2020-03-02","2020-04-30"),ylim = c(-0.16,0.10))

scatterplot(y~indices|date, boxplots=FALSE, smooth=TRUE, reg.line=FALSE, data=mydata, ylim = c(-0.16,0.10))

output

mydata<- read.csv("data_1.csv")
mydata$date <- dmy(mydata$date)

y <- mydata$return
x <- mydata$COVID19_new_cases
coplot(y ~ indices|date, type="l", data=mydata, xlim = c("2020-03-02","2020-04-30"),ylim = c(-0.16,0.10))
Error in plot.window(xlim, ylim) : invalid 'xlim' value
coplot(y ~ indices|date, type="b", data=mydata, xlim = c("2020-03-02","2020-04-30"),ylim = c(-0.16,0.10))
Error in plot.window(xlim, ylim) : invalid 'xlim' value
scatterplot(y~indices|date, boxplots=FALSE, smooth=TRUE, reg.line=FALSE, data=mydata, ylim = c(-0.16,0.10))
Error in plot.window(...) : need finite 'xlim' values
In addition: Warning messages:
1: In xy.coords(x, y, xlabel, ylabel, log) : NAs introduced by coercion
2: In min(x) : no non-missing arguments to min; returning Inf
3: In max(x) : no non-missing arguments to max; returning -Inf
4: In plot.window(...) : "reg.line" is not a graphical parameter

data

indices date return covid19_new_cases
CAC40 02-03-2020 -0.015 30
CAC40 03-03-2020 -0.003 48
CAC40 04-03-2020 0.012 34
CAC40 05-03-2020 -0.024 73
CAC40 06-03-2020 -0.022 138
CAC40 11-03-2020 -0.022 372
CAC40 12-03-2020 -0.076 497
CAC40 13-03-2020 -0.027 595
CAC40 16-03-2020 -0.001 924
CAC40 17-03-2020 -0.012 1210
CAC40 18-03-2020 -0.039 1097
CAC40 19-03-2020 0.006 1404
CAC40 20-03-2020 -0.004 1861
CAC40 23-03-2020 0.012 1559
CAC40 24-03-2020 0.038 3838
CAC40 25-03-2020 0.021 2446
CAC40 26-03-2020 0.049 2931
CAC40 27-03-2020 -0.019 3922
CAC40 30-03-2020 0.004 2599
CAC40 31-03-2020 -0.009 4376
CAC40 01-04-2020 -0.012 7578
CAC40 03-04-2020 -0.012 2116
CAC40 07-04-2020 -0.011 3912
CAC40 08-04-2020 0.01 3777
CAC40 09-04-2020 -0.001 3881
CAC40 13-04-2020 -0.007 4253
CAC40 15-04-2020 -0.035 5497
CAC40 16-04-2020 -0.012 2633
CAC40 17-04-2020 0.006 2641
CAC40 20-04-2020 -0.001 785
CAC40 21-04-2020 -0.025 2051
CAC40 22-04-2020 0.007 2667
CAC40 23-04-2020 0 1827
CAC40 24-04-2020 0.001 1653
CAC40 27-04-2020 0.006 461
CAC40 28-04-2020 0.014 1195
CAC40 29-04-2020 0.023 1065
CAC40 30-04-2020 -0.026 1607
DAX 02-03-2020 -0.014 18
DAX 03-03-2020 -0.002 28
DAX 04-03-2020 0.011 39
DAX 05-03-2020 -0.02 66
DAX 06-03-2020 -0.013 138
DAX 11-03-2020 -0.015 157
DAX 12-03-2020 -0.071 271
DAX 13-03-2020 -0.026 802
DAX 16-03-2020 0.002 1043
DAX 17-03-2020 -0.022 1174
DAX 18-03-2020 -0.02 1144
DAX 19-03-2020 0.013 1042
DAX 20-03-2020 -0.017 5940
DAX 23-03-2020 0.024 3311
DAX 24-03-2020 0.05 4438
DAX 25-03-2020 -0.011 2342
DAX 26-03-2020 0.039 4954
DAX 27-03-2020 -0.016 5780
DAX 30-03-2020 0.009 4751
DAX 31-03-2020 -0.004 4615
DAX 01-04-2020 -0.007 5453
DAX 03-04-2020 -0.001 6174
DAX 07-04-2020 -0.01 3834
DAX 08-04-2020 0.003 4003
DAX 09-04-2020 0.007 4974
DAX 13-04-2020 -0.02 4887
DAX 15-04-2020 -0.037 2486
DAX 16-04-2020 -0.011 2866
DAX 17-04-2020 0.002 3380
DAX 20-04-2020 -0.003 1775
DAX 21-04-2020 -0.026 1785
DAX 22-04-2020 0.004 2237
DAX 23-04-2020 0.007 2352
DAX 24-04-2020 0.004 2337
DAX 27-04-2020 0.01 1018
DAX 28-04-2020 0.013 1144
DAX 29-04-2020 0.027 1304
DAX 30-04-2020 -0.03 1478
FTSE_MIB 02-03-2020 -0.03 561
FTSE_MIB 03-03-2020 -0.017 347
FTSE_MIB 04-03-2020 0.009 466
FTSE_MIB 05-03-2020 -0.021 587
FTSE_MIB 06-03-2020 -0.009 769
FTSE_MIB 11-03-2020 -0.013 977
FTSE_MIB 12-03-2020 -0.156 2313
FTSE_MIB 13-03-2020 0.056 2651
FTSE_MIB 16-03-2020 -0.046 2823
FTSE_MIB 17-03-2020 -0.007 4000
FTSE_MIB 18-03-2020 0.009 3526
FTSE_MIB 19-03-2020 0.003 4207
FTSE_MIB 20-03-2020 -0.003 5322
FTSE_MIB 23-03-2020 0.016 5560
FTSE_MIB 24-03-2020 0.061 4789
FTSE_MIB 25-03-2020 0 5249
FTSE_MIB 26-03-2020 0.029 5210
FTSE_MIB 27-03-2020 -0.013 6153
FTSE_MIB 30-03-2020 0.001 5217
FTSE_MIB 31-03-2020 -0.003 4050
FTSE_MIB 01-04-2020 -0.003 4053
FTSE_MIB 03-04-2020 -0.021 4668
FTSE_MIB 07-04-2020 -0.01 3599
FTSE_MIB 08-04-2020 0.01 3039
FTSE_MIB 09-04-2020 -0.004 3836
FTSE_MIB 13-04-2020 -0.012 4092
FTSE_MIB 15-04-2020 -0.042 2972
FTSE_MIB 16-04-2020 -0.014 2667
FTSE_MIB 17-04-2020 -0.006 3786
FTSE_MIB 20-04-2020 -0.005 3047
FTSE_MIB 21-04-2020 -0.021 2256
FTSE_MIB 22-04-2020 0.009 2729
FTSE_MIB 23-04-2020 0.005 3370
FTSE_MIB 24-04-2020 0.013 2646
FTSE_MIB 27-04-2020 0.004 2324
FTSE_MIB 28-04-2020 0.014 1739
FTSE_MIB 29-04-2020 0.026 2091
FTSE_MIB 30-04-2020 -0.028 2086
FTSE100 02-03-2020 0.011 5
FTSE100 03-03-2020 0.01 22
FTSE100 04-03-2020 0.014 40
FTSE100 05-03-2020 -0.016 55
FTSE100 06-03-2020 -0.036 56
FTSE100 11-03-2020 -0.014 148
FTSE100 12-03-2020 -0.109 259
FTSE100 13-03-2020 0.025 406
FTSE100 16-03-2020 -0.04 361
FTSE100 17-03-2020 0.028 442
FTSE100 18-03-2020 -0.04 611
FTSE100 19-03-2020 0.014 769
FTSE100 20-03-2020 0.008 999
FTSE100 23-03-2020 -0.038 1198
FTSE100 24-03-2020 0.091 1378
FTSE100 25-03-2020 0.044 2338
FTSE100 26-03-2020 0.022 2375
FTSE100 27-03-2020 -0.053 2692
FTSE100 30-03-2020 0.01 2822
FTSE100 31-03-2020 0.019 2858
FTSE100 01-04-2020 -0.038 4273
FTSE100 03-04-2020 -0.012 4913
FTSE100 07-04-2020 0.022 3592
FTSE100 08-04-2020 -0.005 5282
FTSE100 09-04-2020 0.029 5450
FTSE100 13-04-2020 -0.001 4702
FTSE100 15-04-2020 -0.033 4178
FTSE100 16-04-2020 0.005 4326
FTSE100 17-04-2020 0.028 5065
FTSE100 20-04-2020 0.004 4721
FTSE100 21-04-2020 -0.03 3853
FTSE100 22-04-2020 0.023 4854
FTSE100 23-04-2020 0.01 4760
FTSE100 24-04-2020 -0.013 5487
FTSE100 27-04-2020 0.016 3748
FTSE100 28-04-2020 0.019 3473
FTSE100 29-04-2020 0.026 4706
FTSE100 30-04-2020 -0.035 4729
IBEX35 02-03-2020 -0.019 54
IBEX35 03-03-2020 -0.005 56
IBEX35 04-03-2020 0.009 75
IBEX35 05-03-2020 -0.031 81
IBEX35 06-03-2020 -0.018 183
IBEX35 11-03-2020 -0.02 975
IBEX35 12-03-2020 -0.092 1153
IBEX35 13-03-2020 -0.02 1531
IBEX35 16-03-2020 -0.035 1706
IBEX35 17-03-2020 0.008 2503
IBEX35 18-03-2020 -0.015 3694
IBEX35 19-03-2020 0.004 4047
IBEX35 20-03-2020 -0.03 4569
IBEX35 23-03-2020 0.001 4646
IBEX35 24-03-2020 0.044 7691
IBEX35 25-03-2020 -0.006 8553
IBEX35 26-03-2020 0.036 8954
IBEX35 27-03-2020 -0.02 9181
IBEX35 30-03-2020 -0.013 5813
IBEX35 31-03-2020 0.006 8145
IBEX35 01-04-2020 -0.007 7413
IBEX35 03-04-2020 0.003 7272
IBEX35 07-04-2020 0.002 5209
IBEX35 08-04-2020 0.003 5583
IBEX35 09-04-2020 0.003 5745
IBEX35 13-04-2020 0.001 6244
IBEX35 15-04-2020 -0.032 4424
IBEX35 16-04-2020 -0.024 3820
IBEX35 17-04-2020 -0.01 3818
IBEX35 20-04-2020 -0.015 2218
IBEX35 21-04-2020 -0.016 2951
IBEX35 22-04-2020 0.005 2312
IBEX35 23-04-2020 -0.002 2916
IBEX35 24-04-2020 -0.004 2114
IBEX35 27-04-2020 -0.007 1660
IBEX35 28-04-2020 0.017 1525
IBEX35 29-04-2020 0.033 847
IBEX35 30-04-2020 -0.023 1241
NASDAQ_composite 02-03-2020 0.033 20
NASDAQ_composite 03-03-2020 -0.031 14
NASDAQ_composite 04-03-2020 0.021 22
NASDAQ_composite 05-03-2020 -0.006 34
NASDAQ_composite 06-03-2020 0.013 74
NASDAQ_composite 11-03-2020 -0.023 271
NASDAQ_composite 12-03-2020 -0.027 287
NASDAQ_composite 13-03-2020 0.035 351
NASDAQ_composite 16-03-2020 -0.066 823
NASDAQ_composite 17-03-2020 0.037 887
NASDAQ_composite 18-03-2020 0.013 1766
NASDAQ_composite 19-03-2020 0.022 2988
NASDAQ_composite 20-03-2020 -0.051 4835
NASDAQ_composite 23-03-2020 0.002 8459
NASDAQ_composite 24-03-2020 0.031 11236
NASDAQ_composite 25-03-2020 -0.005 8789
NASDAQ_composite 26-03-2020 0.045 13963
NASDAQ_composite 27-03-2020 -0.007 16797
NASDAQ_composite 30-03-2020 0.025 18360
NASDAQ_composite 31-03-2020 -0.005 21595
NASDAQ_composite 01-04-2020 -0.013 24998
NASDAQ_composite 03-04-2020 -0.014 28819
NASDAQ_composite 07-04-2020 -0.03 30561
NASDAQ_composite 08-04-2020 0.014 30613
NASDAQ_composite 09-04-2020 -0.002 33323
NASDAQ_composite 13-04-2020 0.008 27620
NASDAQ_composite 15-04-2020 0.004 26922
NASDAQ_composite 16-04-2020 0.006 30148
NASDAQ_composite 17-04-2020 -0.002 31667
NASDAQ_composite 20-04-2020 0.001 24601
NASDAQ_composite 21-04-2020 -0.023 28065
NASDAQ_composite 22-04-2020 0.007 37289
NASDAQ_composite 23-04-2020 -0.004 17588
NASDAQ_composite 24-04-2020 0.012 26543
NASDAQ_composite 27-04-2020 0.001 26857
NASDAQ_composite 28-04-2020 -0.025 22541
NASDAQ_composite 29-04-2020 0.013 24132
NASDAQ_composite 30-04-2020 -0.002 27326
NIFTY50 02-03-2020 -0.022 0
NIFTY50 03-03-2020 0.008 2
NIFTY50 04-03-2020 -0.009 1
NIFTY50 05-03-2020 -0.003 22
NIFTY50 06-03-2020 0.004 1
NIFTY50 11-03-2020 0.012 6
NIFTY50 12-03-2020 -0.045 23
NIFTY50 13-03-2020 0.093 2
NIFTY50 16-03-2020 -0.041 3
NIFTY50 17-03-2020 -0.034 32
NIFTY50 18-03-2020 -0.068 12
NIFTY50 19-03-2020 0.025 28
NIFTY50 20-03-2020 0.056 26
NIFTY50 23-03-2020 -0.042 119
NIFTY50 24-03-2020 -0.006 53
NIFTY50 25-03-2020 0.075 70
NIFTY50 26-03-2020 0.023 87
NIFTY50 27-03-2020 -0.032 75
NIFTY50 30-03-2020 -0.013 92
NIFTY50 31-03-2020 0.008 180
NIFTY50 01-04-2020 -0.038 146
NIFTY50 03-04-2020 -0.033 336
NIFTY50 07-04-2020 0.041 354
NIFTY50 08-04-2020 0.007 773
NIFTY50 09-04-2020 0.015 540
NIFTY50 13-04-2020 -0.012 796
NIFTY50 15-04-2020 -0.029 1075
NIFTY50 16-04-2020 0.016 942
NIFTY50 17-04-2020 -0.006 1007
NIFTY50 20-04-2020 -0.014 1553
NIFTY50 21-04-2020 -0.004 1335
NIFTY50 22-04-2020 0.018 1384
NIFTY50 23-04-2020 0.009 1409
NIFTY50 24-04-2020 -0.001 1684
NIFTY50 27-04-2020 0.002 1396
NIFTY50 28-04-2020 -0.001 1543
NIFTY50 29-04-2020 0.015 1897
NIFTY50 30-04-2020 0.011 1718
Nikkei225 02-03-2020 0.024 15
Nikkei225 03-03-2020 -0.026 0
Nikkei225 04-03-2020 0.01 14
Nikkei225 05-03-2020 -0.003 49
Nikkei225 06-03-2020 -0.012 32
Nikkei225 11-03-2020 -0.017 54
Nikkei225 12-03-2020 -0.026 51
Nikkei225 13-03-2020 -0.041 56
Nikkei225 16-03-2020 -0.033 34
Nikkei225 17-03-2020 0.017 10
Nikkei225 18-03-2020 -0.025 5
Nikkei225 19-03-2020 -0.026 44
Nikkei225 20-03-2020 -0.021 37
Nikkei225 23-03-2020 0.019 43
Nikkei225 24-03-2020 0.051 39
Nikkei225 25-03-2020 0.06 65
Nikkei225 26-03-2020 -0.03 75
Nikkei225 27-03-2020 0.019 96
Nikkei225 30-03-2020 0.011 173
Nikkei225 31-03-2020 -0.014 87
Nikkei225 01-04-2020 -0.033 0
Nikkei225 03-04-2020 -0.007 439
Nikkei225 07-04-2020 0.004 252
Nikkei225 08-04-2020 0.016 351
Nikkei225 09-04-2020 -0.002 511
Nikkei225 13-04-2020 -0.014 507
Nikkei225 15-04-2020 -0.002 455
Nikkei225 16-04-2020 -0.001 482
Nikkei225 17-04-2020 0.016 585
Nikkei225 20-04-2020 -0.001 390
Nikkei225 21-04-2020 -0.01 367
Nikkei225 22-04-2020 0.002 378
Nikkei225 23-04-2020 0.006 276
Nikkei225 24-04-2020 -0.004 468
Nikkei225 27-04-2020 0.019 203
Nikkei225 28-04-2020 0 191
Nikkei225 29-04-2020 0.005 303
Nikkei225 30-04-2020 0.004 236
SSE_composite 02-03-2020 0.025 205
SSE_composite 03-03-2020 -0.005 127
SSE_composite 04-03-2020 0.01 119
SSE_composite 05-03-2020 0.012 117
SSE_composite 06-03-2020 -0.002 170
SSE_composite 11-03-2020 -0.011 29
SSE_composite 12-03-2020 -0.004 24
SSE_composite 13-03-2020 0.03 22
SSE_composite 16-03-2020 -0.037 25
SSE_composite 17-03-2020 -0.006 43
SSE_composite 18-03-2020 -0.023 23
SSE_composite 19-03-2020 -0.006 44
SSE_composite 20-03-2020 0.007 99
SSE_composite 23-03-2020 -0.007 138
SSE_composite 24-03-2020 0.007 69
SSE_composite 25-03-2020 0.002 78
SSE_composite 26-03-2020 0.001 102
SSE_composite 27-03-2020 -0.007 94
SSE_composite 30-03-2020 0.003 98
SSE_composite 31-03-2020 -0.006 84
SSE_composite 01-04-2020 -0.003 54
SSE_composite 03-04-2020 -0.003 70
SSE_composite 07-04-2020 0.005 56
SSE_composite 08-04-2020 0.003 86
SSE_composite 09-04-2020 0 86
SSE_composite 13-04-2020 -0.001 112
SSE_composite 15-04-2020 -0.005 49
SSE_composite 16-04-2020 0.008 50
SSE_composite 17-04-2020 0.001 352
SSE_composite 20-04-2020 0.004 14
SSE_composite 21-04-2020 -0.005 32
SSE_composite 22-04-2020 0.011 15
SSE_composite 23-04-2020 -0.004 12
SSE_composite 24-04-2020 -0.009 8
SSE_composite 27-04-2020 0.001 3
SSE_composite 28-04-2020 -0.004 26
SSE_composite 29-04-2020 0.008 2
SSE_composite 30-04-2020 0.01 4
2

Your first problem is that you need to define xlim as dates.

Try this

xl <- ymd("2020-03-02","2020-04-30")

coplot( mydata$return ~ indices|date, type="l", data=mydata, xlim = xl ,ylim = c(-0.16,0.10))

Then there is another problem but I am unfamiliar with coplot and it is too late for me to try anything tonight.

This may help a bit.

1 Like
3

Okay, awake and on my second cup of tea.

I read indices in s character data.

So

mydata<- read.csv("data_1.csv", sep="\t", header=TRUE, stringsAsFactors = FALSE)

mydata$date <- dmy(mydata$date)
mydata$indices <- as.factor(mydata$indices)

xl <- ymd("2020-03-02","2020-04-30")

coplot( mydata$return ~ indices|date, type="l", data=mydata, xlim = xl ,ylim = c(-0.16,0.10))

gives a result with no errors or warnings but I have no idea if the output means anything.

BTW, if possible when supplying data the best way is to use dput() output.

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.