StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POData type issue, integer data into R from csv
primarykey
Id
8041609
data
AcceptedAnswerId
8041932
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-07T19:40:52.430
FavoriteCount
0
LastActivityDate
2015-11-03T12:21:47.300
LastEditDate
2015-11-03T12:21:47.300
LastEditorUserId
1505120
OwnerUserId
1030648
ParentId
0
PostTypeId
1
Score
2
ViewCount
885
LastEditorDisplayName
text
Body
I have a data.frame in R which has been constructed off the Example 1-3 dataset here: <a href="http://riskfactor.cancer.gov/diet/usualintakes/dataset.html" rel="nofollow">http://riskfactor.cancer.gov/diet/usualintakes/dataset.html</a> I converted it from SAS to ASCII using Stat Transfer, saving as a csv. I have imported the data into R using the read.csv command: <pre><code>t_0104nc <- read.csv("foo.csv",header=T) </code></pre> The data are in data.frame structure. Within this file are some columns that relate to weights (RNDW through RNDW32). While these appear to be integers, when looking at the data in Excel, the cells have General format. R has brought the data in as double. I'm using RNDW1, and I need to confirm that it is integer. However, entering typeof(RNDW1) and storage.mode(RNDW1) both show the data as double. What is the most efficient way for me to test that I only have integer values in that column? I don't want to coerce the data, as the existence of non-integers would indicate a fundamental problem with the data that coercing won't fix. Alternatively, I was wondering if there was some way of importing the data so it stored as the simplest data type in R - which should then import these values as integer. Some of the data is integer, other data is single or double, so the data is not all the same type. Update from the suggestions below. All I need is a simple boolean true/false test, so I have used: <code>if(isTRUE(all.equal(x, xi <- as.integer(x)))) y="TRUE" else y="FALSE"</code> <code>y</code> Which then returns me a single true or false value to indicate the overall result of the test. I appreciate all the (rapid!) help I received, and I am happy with the code and my understanding of it.
Tags
<r><csv>
Title
Data type issue, integer data into R from csv
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USpnuts
UserOwnerUserId
1. USMichelle
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POData type issue, integer data into R from csv
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POData type issue, integer data into R from csv
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.