On 15 July 2020 at 16:16, Sam H wrote:
| I am trying to download some data using read.csv and it works perfectly in
| RStudio and fails in the R console in the terminal in Ubuntu 18.04 after
| upgrading from R 3.6.3 to 4.0.2. Before upgrading this worked in the R
| console in the terminal also without any issues.
| 
| Why would that be? How to fix this?
| 
| Below please find R code output and sessionInfo().
| 
| *Works in RStudio*
| 
| > 
read.csv("https://old.nasdaq.com/screening/companies-by-name.aspx?letter=0&exchange=1&render=download";,
 header=TRUE, as.is=TRUE, na="n/a")

Ok, let's stop right here.  First off, for good debugging it helps to separate

 - downloading a file via R from
 - reading a file
 - maybe varying the arguments you give there

In my case this got easier. I clicked on the link (in Ubuntu 20.04) and it
downloaded it. From there few problems. `read.csv()` just reads it:

edd@rob:~/Downloads$ Rscript -e 'data.table::fread("companylist.csv", 
header=TRUE)'
      Symbol                                   Name LastSale MarketCap IPOyear  
          Sector                                                     industry   
                    Summary Quote V9
   1:    TXG                     10x Genomics, Inc.    88.91    $8.75B    2019  
   Capital Goods             Biotechnology: Laboratory Analytical Instruments   
https://old.nasdaq.com/symbol/txg NA
   2:     YI                              111, Inc.     6.64  $546.87M    2018  
     Health Care                                     Medical/Nursing Services   
 https://old.nasdaq.com/symbol/yi NA
   3:    PIH 1347 Property Insurance Holdings, Inc.    4.528   $27.48M    2014  
         Finance                                   Property-Casualty Insurers   
https://old.nasdaq.com/symbol/pih NA
   4:  PIHPP 1347 Property Insurance Holdings, Inc.  24.8631       n/a     n/a  
         Finance                                   Property-Casualty Insurers 
https://old.nasdaq.com/symbol/pihpp NA
   5:   TURN               180 Degree Capital Corp.     1.67   $51.97M     n/a  
         Finance                                   Finance/Investors Services  
https://old.nasdaq.com/symbol/turn NA
  ---                                                                           
                                                                                
                                    
3622:     ZS                          Zscaler, Inc.   122.43   $15.98B    2018  
      Technology                                                 EDP Services   
 https://old.nasdaq.com/symbol/zs NA
3623:   ZUMZ                            Zumiez Inc.    25.55  $649.76M    2005 
Consumer Services                               Clothing/Shoe/Accessory Stores  
https://old.nasdaq.com/symbol/zumz NA
3624:   ZYNE          Zynerba Pharmaceuticals, Inc.     3.41   $85.08M    2015  
     Health Care                                        Major Pharmaceuticals  
https://old.nasdaq.com/symbol/zyne NA
3625:   ZYXI                            Zynex, Inc.    26.22  $870.31M     n/a  
     Health Care Biotechnology: Electromedical & Electrotherapeutic Apparatus  
https://old.nasdaq.com/symbol/zyxi NA
3626:   ZNGA                             Zynga Inc.     9.82   $10.54B    2011  
      Technology                                                 EDP Services  
https://old.nasdaq.com/symbol/znga NA
edd@rob:~/Downloads$

For kicks, same with data.table:

edd@rob:~/Downloads$ Rscript -e 'str(read.csv("companylist.csv"))'
'data.frame':   3626 obs. of  9 variables:
 $ Symbol       : chr  "TXG" "YI" "PIH" "PIHPP" ...
 $ Name         : chr  "10x Genomics, Inc." "111, Inc." "1347 Property 
Insurance Holdings, Inc." "1347 Property Insurance Holdings, Inc." ...
 $ LastSale     : chr  "88.91" "6.64" "4.528" "24.8631" ...
 $ MarketCap    : chr  "$8.75B" "$546.87M" "$27.48M" "n/a" ...
 $ IPOyear      : chr  "2019" "2018" "2014" "n/a" ...
 $ Sector       : chr  "Capital Goods" "Health Care" "Finance" "Finance" ...
 $ industry     : chr  "Biotechnology: Laboratory Analytical Instruments" 
"Medical/Nursing Services" "Property-Casualty Insurers" "Property-Casualty 
Insurers" ...
 $ Summary.Quote: chr  "https://old.nasdaq.com/symbol/txg"; 
"https://old.nasdaq.com/symbol/yi"; "https://old.nasdaq.com/symbol/pih"; 
"https://old.nasdaq.com/symbol/pihpp"; ...
 $ X            : logi  NA NA NA NA NA NA ...
edd@rob:~/Downloads$ 

So in short, if you have a problem, it is not likely coming from the Ubuntu
binary for R 4.0.2 which I am running here.

Maybe start by downloading the file?  You could have firewall or other
issues. We can't tell. And we can't reproduce the issue.

Good luck,  Dirk
 
-- 
https://dirk.eddelbuettel.com | @eddelbuettel | e...@debian.org

_______________________________________________
R-SIG-Debian mailing list
R-SIG-Debian@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-debian

Reply via email to