I have a CSV file which contains two format(General and Date) for Date Column. Having issue in while working with R - 


    > df<-read.csv("weatherdatatrail.csv")     > header=t     > df$date     [1] 01-01-1989 01-02-1989 01-03-1989 01-04-1989 01-05-1989 01-06-1989     [7] 01-07-1989 01-08-1989 01-09-1989 01-10-1989 01-11-1989 01-12-1989     [13] 1/13/1989  1/14/1989  1/15/1989  1/16/1989  1/17/1989  1/18/1989      [19] 1/19/1989  1/20/1989  1/21/1989  1/22/1989  1/23/1989  1/24/1989      [25] 1/25/1989  1/26/1989  1/27/1989  1/28/1989  1/29/1989  1/30/1989      [31] 1/31/1989      31 levels: 01-01-1989 01-02-1989 01-03-1989 01-04-1989 ... 1/31/1989

while performing r below code, works general format date format showing na..

   > df$date<-as.date(as.character(df$date),format="%m/%d/%y")    > str(df)    'data.frame':   31 obs. of  10 variables:     $ date             : date, format: na na ...     $ longitude        : num  77.2 77.2 77.2 77.2 77.2 ...     $ latitude         : num  11.4 11.4 11.4 11.4 11.4 ...     $ elevation        : int  282 282 282 282 282 282 282 282 282 282 ...     $ max.temperature  : num  28.2 28.5 29.6 29.3 27.9 ...     $ min.temperature  : num  10.9 15.4 14.2 16.5 16.3 ...     $ precipitation    : num  0 0.0378 0.0893 0.2077 0.1785 ...     $ wind             : num  2.17 2.1 2.03 2.05 2.09 ...     $ relative.humidity: num  0.559 0.705 0.718 0.779 0.781 ...     $ solar            : num  21 20.5 19.3 19.2 14.8 ...      > df$date    [1] na           na           na           na           na              [6] na           na           na           na           na              [11] na           na           "1989-01-13" "1989-01-14" "1989-01-15"    [16] "1989-01-16" "1989-01-17" "1989-01-18" "1989-01-19" "1989-01-20"    [21] "1989-01-21" "1989-01-22" "1989-01-23" "1989-01-24" "1989-01-25"    [26] "1989-01-26" "1989-01-27" "1989-01-28" "1989-01-29" "1989-01-30"    [31] "1989-01-31"

i unable pull perfect result.. please me out

you use library(lubridate) (as commented @mrflick)

library(lubridate) as.date(mdy(v1)) #[1] "1989-01-01" "1989-01-02" "1989-01-15"

data

v1 <- c("01-01-1989", "01-02-1989", "1/15/1989")

Comments

Post a Comment

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

i have following sample code used pre-decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(--c); cout << c << endl; return; } } this function give output input 4 : dp3 dp2 dp1 dp0 0 1 2 3 but when use post decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(c--); cout << c << endl; return; } } output goes in infinite loop dp4 can explain me in detail why happens ? this happens because function(c--) called same value of c , when finishes c decremented. recursively called, hence called same value no chance of return , hit stack overflow error. assume this, int x = 1, y = 0; y = x++ result y == 1 , x == 2. if y = ++x , bot x , y 2.
Read more

c# - Retrieve google contact -

i'm using .net retrieve contact info google contact. however, retrieves including sent email not stored in contact. there anyway can retrieve contact contact? here code requestsettings rs = new requestsettings("", email, password); rs.autopaging = true; contactsrequest cr = new contactsrequest(rs); feed<contact> contacts = cr.getcontacts(); foreach (contact contact in contacts.entries) { name name = contact.name; response.write(name.givenname + " " + name.familyname + "<br/>"); foreach (email emailid in contact.emails) { response.write(emailid.address + "<br/>"); } response.write("<br/>"); } im using google.gdata.contacts package nuget v 2.2.0 string redirecturi = "urn:ietf:wg:oauth:2.0:oob"; // build base oauth2 parameters var oauth2
Read more

javascript - How to insert selected radio button value into table cell -

i have 5 radio buttons <input type="radio" id="rating">1 <input type="radio" id="rating2">2 <input type="radio" id="rating3">3 <input type="radio" id="rating4">4 <input type="radio" id="rating5">5 i have 1 table <table id="mytabledata" border="1" style="width:100%"> <tr id="templaterow"> <th>ratings</th> </tr> </table> one add button <input type="button" id="add" value="add" onclick="addradiovalue()"> i've written code dynamically add rows table, when select radio button , click on add button, value of selected radio button should inserted new cell within table ratings. i able thing text box, i'm not able radio button. can me? your problems didn't have name set on radios , tryi
Read more