stan125 / grea Goto Github PK
View Code? Open in Web Editor NEWGotta Read Em All: RStudio Add-In to interactively read ALL the data into R
Gotta Read Em All: RStudio Add-In to interactively read ALL the data into R
Please take this suggestion with a grain of salt since I am the (co-)author of the package, but why not use rio to handle the file importing? This way you don't need to reimplement all of the complex handling of file types, etc. No pressure, of course.
read.table(file = "2022_Ass2Data.csv", sep = ",", dec = ".", header = TRUE, na.strings = "-99,--")
read.table(file = "2022_Ass2Data.csv", sep = ",", dec = ".", header = TRUE, na.strings = c("-99","--"))
Clearly, this only works for a single missing value placeholder.
na.strings needs to be string-split into a vector based on ","
Hi Stan -
I followed the instructions to install this addin but got the following error. Can you please help resolve this?
devtools::install_github("Stan125/GREA")
Downloading GitHub repo Stan125/GREA@master
Error in packageVersion("curl") : package ‘curl’ not found
Can you please help resolve this?
Thanks!
After installed all require packages, I run this code:
devtools::install_github("Stan125/GREA")
Here's result
Downloading GitHub repo Stan125/GREA@master
from URL https://api.github.com/repos/Stan125/GREA/zipball/master
Installing GREA
"F:/Programming/R/R-3.3.1/bin/x64/R" --no-site-file --no-environ
--no-save --no-restore --quiet CMD INSTALL "D:/DATA/App
Cache/WindowsTemp/Temp/Rtmp4Aq6YN/devtools35b428f40be/Stan125-GREA-e80db34"
--library="F:/Programming/R/R-3.3.1/library" --install-tests
- installing source package 'GREA' ...
** R
** inst
** preparing package for lazy loading
** help
*** installing help indices
** building package indices
** testing if installed package can be loaded
*** arch - i386
ARGUMENT 'Cache\WindowsTemp\Temp\Rtmpwh8yJW\Rin36a86eb36998' ignoredError: unexpected symbol in "Microsoft DiskPart"
Execution halted
*** arch - x64
ARGUMENT 'Cache\WindowsTemp\Temp\Rtmpwh8yJW\Rin36a878dd7c2a' ignoredError: unexpected symbol in "Microsoft DiskPart"
Execution halted
ERROR: loading failed for 'i386', 'x64'
- removing 'F:/Programming/R/R-3.3.1/library/GREA'
Error: Command failed (1)
Dear sirs,
I´m trying to import a single spreadsheet (attached) and it doesn´t parse at all.
The print screen is also attached.
Thanks for any help in advance!
There's a BI department at my work that stores data as QVD files. I would love to load them using R.
The file explorer shouldn't be opened in the user home directory but in the current working directory. It is very likely that files relevant for the current project will be located there.
I've been trying GREA.
It works well with csv files,
but when importing SPSS SAV files I can't get the preview and when I press "Done" I get this error:
Listening on http://127.0.0.1:5670
- Wrong options for generating df, or
- Outcome is not a df (for Excel and SPSS reader functions)
Though, if I use haven or foreign to import it it works well.
Hi Stan125,
thanks a lot for building up this addin.
I'm wondering if you'd like to add one optional function to the seperator which enables one choosing the separator that is not included in your list? I think it would be very helpful for many users.
Best,
meged
The filename that I imported was named something like salmon-x.csv. The auto-suggested name would then be salmon-x which is not a legal R variable name and gets interpreted as a calculation with R complaining that object 'salmon' not found.
The workaround is simple enough, I just overwrote the suggested name.
It might be preferable to replace the '-' character by underscores in the suggested name. Of course there might be other characters such as '+' that are legal in filenames but might not be R-friendly.
Dear Stan,
I'd like to ask if you can make it possible to set the type per variable with simple drop-down menu, so I can easily set to date, character, numeric, factor, etc. This would be so helpful, as it takes me forever each time.
If additionally I could set the labels interactively aswell, that would be amazing.
Great Work
Best Wishes
I've tried installing this with MRO 3.3.0 64bit, R 3.3.0 64bit and 32bit all on Win7. It gives similar errors.
I also tried doing this in Rstudio and the R command prompt. Same errors.
devtools::install_github("Stan125/GREA")
Downloading GitHub repo Stan125/GREA@master
from URL https://api.github.com/repos/Stan125/GREA/zipball/master
Installing GREA
"C:/PROGRA1/R/R-331.0/bin/x64/R" --no-site-file --no-environ --no-save
--no-restore --quiet CMD INSTALL
"C:/Users/[user]/AppData/Local/Temp/Rtmp4Qvf49/devtools2bb019b06959/Stan125-GREA-8eb2b3f"
--library="\clus-file-01/userdirs/[user]/Documents/R/win-library/3.3"
--install-tests
Perhaps it's because my R lib folder is a network share?
I quickly tried installing it on my Ubuntu Mate box, and that worked fine. So I'm pretty sure it's something odd about the setup on my Windows machine.
I think it would be good if your package generated the appropriate code to open the file in a non-interactive mode.
This way, the user doesn't have to go through a interactive process every single time they want to re-run the code. Interactive is good for user experience, especially for novices, but it is more time consuming.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.