Using R to download zipped data file, extract, and import data

Posted by Jeromy Anglim on Stack Overflow See other posts from Stack Overflow or by Jeromy Anglim
Published on 2010-06-16T13:52:05Z Indexed on 2010/06/16 15:32 UTC
Read the original article Hit count: 266

Filed under:

r

|

zip

|

connections

@EZGraphs on Twitter writes: "Lots of online csvs are zipped. Is there a way to download, unzip the archive, and load the data to a data.frame using R? #Rstats"

I was also trying to do this today, but ended up just downloading the zip file manually.

I tried something like:

fileName <- "http://www.newcl.org/data/zipfiles/a1.zip"
con1 <- unz(fileName, filename="a1.dat", open = "r")

but I feel as if I'm a long way off. Any thoughts?

Related posts about zip

More CPU cores may not always lead to better performance – MAXDOP and query memory distribution in spotlight

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
More hardware normally delivers better performance, but there are exceptions where it can hinder performance. Understanding these exceptions and working around it is a major part of SQL Server performance tuning. When a memory allocating query executes in parallel, SQL Server distributes… >>> More
Cisco Unifed Communication integration for Microsoft Lync crashes on Remote Desktop services 2008 R2!

as seen on Server Fault - Search for 'Server Fault'
Hi everybody i have deployed office communication server 2007 R2 and communicator 2007 R2 and i made integration with Cisco Unified Communication Manager 7.1 in my network, i also uses Remote Desktop Servers 2008 R2 for Thin Client Computers, now that i installed Cisco UC integration client for communicator… >>> More
Cisco Unified Communication integration for Microsoft Lync crashes on Remote Desktop services 2008 R2!

as seen on Server Fault - Search for 'Server Fault'
Hi everybody i have deployed office communication server 2007 R2 and communicator 2007 R2 and i made integration with Cisco Unified Communication Manager 7.1 in my network, i also use Remote Desktop Servers 2008 R2 for Thin Client Computers, now that i installed Cisco UC integration client for communicator… >>> More
zip multiple file on the fly and download it as a zip folder php

as seen on Stack Overflow - Search for 'Stack Overflow'
I understand that I can zip multiple file and download it as zip when the files are already exists on ther server. like this. My question is, I have a dropdown list that prompt user download different section of a big form on the fly so I have header below for download it individually. header("Content-type:… >>> More
Have powershell zip the contents of a bunch of folders, individual zip for each folder

as seen on Super User - Search for 'Super User'
Recently, I asked how to do this with a .bat file and an answer was provided. for /D %%d in (*.*) do "C:\Program Files\7-Zip\7z\7za.exe" a -tzip %%d.zip %%d However, this proved useful only for folders that have no spaces in their name. The reason being that batch will do the following: if the… >>> More

Developer IT

Using R to download zipped data file, extract, and import data - Developer IT

Using R to download zipped data file, extract, and import data

r

zip

connections

Related posts about r

Related posts about zip

More CPU cores may not always lead to better performance – MAXDOP and query memory distribution in spotlight

Cisco Unifed Communication integration for Microsoft Lync crashes on Remote Desktop services 2008 R2!

Cisco Unified Communication integration for Microsoft Lync crashes on Remote Desktop services 2008 R2!

zip multiple file on the fly and download it as a zip folder php

Have powershell zip the contents of a bunch of folders, individual zip for each folder

Categories cloud