I am getting SSL Connect error while runnin ghte below code from RStusio 2024 version:
url_btc <- "https://www.coingecko.com/price_charts/export/1/usd.csv "
btc=read.csv(file=url_btc)
test.csv <- read.csv("https://stats.idre.ucla.edu/stat/data/test.csv ", header = TRUE)
################Ultimate Test
crypto_list() %>% filter(id=="1")
I can go to the Browser and have no issues but from RStudio, i get error
Any advice on how to update ssl certificates on R ?
Here is the full error i get:
l_btc <- "http://www.coingecko.com/price_charts/export/1/btc-usd-max.csv "
btc=read.csv(file=url_btc)
Error in file(file, "rt") :
cannot open the connection to 'http://www.coingecko.com/price_charts/export/1/btc-usd-max.csv '
In addition: Warning message:
In file(file, "rt") :
URL 'https://www.coingecko.com/price_charts/export/1/btc-usd-max.csv ': status was 'SSL connect error'
Hi @skhatri , thank you for your question. Welcome.
I'm able to read data from the URL you listed in your first post:
url_btc <- "https://www.coingecko.com/price_charts/export/1/usd.csv"
btc <- read.csv(file = url_btc)
str(btc)
#> 'data.frame': 4174 obs. of 4 variables:
#> $ snapped_at : chr "2013-04-28 00:00:00 UTC" "2013-04-29 00:00:00 UTC" "2013-04-30 00:00:00 UTC" "2013-05-01 00:00:00 UTC" ...
#> $ price : num 135 142 135 117 103 ...
#> $ market_cap : num 1.50e+09 1.58e+09 1.50e+09 1.30e+09 1.15e+09 ...
#> $ total_volume: num 0 0 0 0 0 0 0 0 0 0 ...
Created on 2024-10-02 with reprex v2.1.0
However, the URL listed in your error message begins withhttp
and not https
.
If you use https://www.coingecko.com/price_charts/export/1/usd.csv
does the file load for you?
Still same error and it works from personal laptop, but not from my work laptop. Not sure if there are issues with Firewall or SSL Certificate
system
Closed
January 1, 2025, 3:38pm
5
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed. If you have a query related to it or one of the replies, start a new topic and refer back with a link.