Re: [R] Sanity check in loading large dataframe

2021-08-05 Thread Luigi Marongiu
Ok, so nothing to worry about. Yet, are there other checks I can implement? Thank you On Thu, 5 Aug 2021, 15:40 Duncan Murdoch, wrote: > On 05/08/2021 9:16 a.m., Luigi Marongiu wrote: > > Hello, > > I am using a large spreadsheet (over 600 variables). > > I tried `str` to check the dimensions

Re: [R] Sanity check in loading large dataframe

2021-08-05 Thread Avi Gross via R-help
Luigi, Duncan answered part of your question. My feedback is to consider looking at your data using other tools besides str(). There are ways in base R to get lists of row or column names or count them or ask what types they are and so forth. Printing an entire large object is hard but printing

Re: [R] Long Format data

2021-08-05 Thread Admire Tarisirayi Chirume
Thank you very much, the code worked the trick. Thank you, i appreciate. Alternative email: addtar...@icloud.com/tchir...@rbz.co.zw Skype: admirechirume Call: +263773369884 whatsapp: +818099861504 On Thu, Aug 5, 2021 at 11:53 AM Jim Lemon wrote: > Hi Admire, > I think rep_n_stack in the pretty

[R] Sanity check in loading large dataframe

2021-08-05 Thread Luigi Marongiu
Hello, I am using a large spreadsheet (over 600 variables). I tried `str` to check the dimensions of the spreadsheet and I got ``` > (str(df)) 'data.frame': 302 obs. of 626 variables: $ record_id : int 1 1 1 1 1 1 1 1 1 1 ... $ v1_medicamento___aceta: int 1 NA NA NA NA

Re: [R] Long Format data

2021-08-05 Thread Jim Lemon
Hi Admire, I think rep_n_stack in the prettyR package may do what you want: # download and install the prettyR package install.packages("prettyR") # load the prettyR package library(prettyR) # read in your data ATCdf<-read.csv("BOP_All_Countries.csv",stringsAsFactors=TRUE) # convert the values you