[datatable-help] rbindlist and factors
Alexandre Sieira
alexandre.sieira at gmail.com
Tue May 21 20:11:39 CEST 2013
Thank you, I'll wait for the next release then.
It's do.call("rbind", …) till then, I presume. :)
--
Alexandre Sieira
CISA, CISSP, ISO 27001 Lead Auditor
"The truth is rarely pure and never simple."
Oscar Wilde, The Importance of Being Earnest, 1895, Act I
On 21 de maio de 2013 at 15:09:00, Arunkumar Srinivasan (aragorn168b at gmail.com) wrote:
This was already addressed here:
http://stackoverflow.com/questions/15933846/rbindlist-two-data-tables-where-one-has-factor-and-other-has-character-type-for
And was known to be a bug filed here:
https://r-forge.r-project.org/tracker/index.php?func=detail&aid=2650&group_id=240&atid=975
Which has been fixed in the current development version 1.8.9. (
Fixed by commit 879 in v1.8.9
Hope this helps,
Arun
On Tuesday, May 21, 2013 at 8:06 PM, Alexandre Sieira wrote:
I think I found an unexpected behavior with rbindlist when columns are factors:
> dt1 = data.table(a=as.factor(c("a", "a", "a")))
> dt1
a
1: a
2: a
3: a
> str(dt1)
Classes ‘data.table’ and 'data.frame': 3 obs. of 1 variable:
$ a: Factor w/ 1 level "a": 1 1 1
- attr(*, ".internal.selfref")=<externalptr>
> dt2 = data.table(a=as.factor(c("b", "b", "b")))
> dt2
a
1: b
2: b
3: b
> str(dt2)
Classes ‘data.table’ and 'data.frame': 3 obs. of 1 variable:
$ a: Factor w/ 1 level "b": 1 1 1
- attr(*, ".internal.selfref")=<externalptr>
If I rbind them, I get the expected value - a table with 6 rows, 3 of which have value "a" and 3 with value "b":
> rbind(dt1, dt2)
a
1: a
2: a
3: a
4: b
5: b
6: b
So if I do rbindlist(list(dt1, dt2)), I would expect to get the exact same result, only faster. Unfortunately, that is not the case:
> rbindlist(list(dt1, dt2))
a
1: a
2: a
3: a
4: a
5: a
6: a
> str(rbindlist(list(dt1, dt2)))
Classes ‘data.table’ and 'data.frame': 6 obs. of 1 variable:
$ a: Factor w/ 1 level "a": 1 1 1 1 1 1
- attr(*, ".internal.selfref")=<externalptr>
This was executed with R 3.0.1 and data.table 1.8.8 on a Mac OS X 10.8.3.
Is this expected behavior? Am I missing something?
--
Alexandre Sieira
CISA, CISSP, ISO 27001 Lead Auditor
"The truth is rarely pure and never simple."
Oscar Wilde, The Importance of Being Earnest, 1895, Act I
_______________________________________________
datatable-help mailing list
datatable-help at lists.r-forge.r-project.org
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/datatable-help/attachments/20130521/b7d7a66b/attachment-0001.html>
More information about the datatable-help
mailing list