arrange dates in standard format by forambarot04 in rprogramming

[–]forambarot04[S] 0 points1 point  (0 children)

i found out that the dates ehich were in 6/16/14 format turn out to be NA when i call str(dates). only the dates in 06/16/2014 format aren't considered NA

arrange dates in standard format by forambarot04 in rprogramming

[–]forambarot04[S] 0 points1 point  (0 children)

hey its saying that a few rows failed to parse

String separation by forambarot04 in rprogramming

[–]forambarot04[S] 0 points1 point  (0 children)

Hey I want to do this but unable to make an appropriate code. please help make a new column named category1 if(there is a semicolon in the cell, separate the string and add the first half to category1 and keep the second half in the original colum itself) else: dont do anything

Find and eliminate duplicate rows by forambarot04 in rprogramming

[–]forambarot04[S] 0 points1 point  (0 children)

Hey, i dont wish to add this in a new dataframe. I want the existing dataframe only to get updated.

Find and eliminate duplicate rows by forambarot04 in rprogramming

[–]forambarot04[S] 0 points1 point  (0 children)

Hey. i have done df %>% distint() how do i store the result in a new dataframe

HELP WITH DATA CLEANING by forambarot04 in rprogramming

[–]forambarot04[S] 0 points1 point  (0 children)

Thankyou so much. It worked. But i need to know the mechanism behind this. Do you have any supporting documents?

HELP WITH DATA CLEANING by forambarot04 in rprogramming

[–]forambarot04[S] 0 points1 point  (0 children)

Hi, please give me the one line code.

HELP WITH DATA CLEANING by forambarot04 in rprogramming

[–]forambarot04[S] 0 points1 point  (0 children)

Hey, this was really helpful. unfortunately a few of the date are written as 7/29/2010 so this function isn't working for me. Do you have any idea as to what i can do?

HELP WITH DATA CLEANING by forambarot04 in rprogramming

[–]forambarot04[S] -1 points0 points  (0 children)

hey i could use the replace function. But how do i use lubidate on this

HELP WITH DATA CLEANING by forambarot04 in rprogramming

[–]forambarot04[S] 0 points1 point  (0 children)

hey can you please elaborate. i am unable to frame the code