http://forums.visokio.com/discussions/tagged/dataframe/feed.rss Mon, 30 Oct 17 14:50:49 -0400 Tagged with dataframe - Visokio Forums en-CA http://forums.visokio.com/discussion/3186/importing-data-using-r Mon, 07 Nov 2016 12:29:38 -0500 Cheyam 3186@/discussions
I am trying to use R to import data. This is done via a COM library. The R code works fine in both R-Studio and OmniScope. The issue, however, is that cells with commas in them are getting split into separate columns. Testing the number of dimensions in my final dataframe "output_data" we have correct numbers however when the data is displayed in "preview" mode in the R input block we have an extra 2 columns. Any cells which have text containing commas in them are being split into new fields and the data which should have been in those fields is getting pushed to the right.

I believe the issue is with the R package which Omniscope uses to interact with R. That in converting a dataframe data type in R into a table which Omniscope understands, that it assumes the data is in comma separated format when it really shouldn't do this (its already been put into a data structure being a dataframe). It takes commas in text and splits them into new columns. This is an undesired result.

Does anyone have some advice on how this can be addressed.

Thank you,
Chey]]>