Skip to content

[R-Forge #2622] Add command "fwrite" to faster save csv files  #580

Description

@arunsrinivasan

Submitted by: Ma Jom; Assigned to: Nobody; R-Forge link

I really love the new command "fread" as it really speeds up the work with large files. It would be great to see a corresponding command for writing CSV files.

Currently, I use a combination of write.csv and as.matrix to speed up this process a bit:
http://stackoverflow.com/questions/10505605/speeding-up-the-performance-of-write-table

Activity

  1. abfleishman commented on Oct 20, 2014

    @abfleishman

    Is this in the works? I am dealing with the same problem

  2. mattdowle commented on Oct 21, 2014

    @mattdowle
    Member

    @abfleishman @robbyjo We're not working on it currently. Contributions are more than welcome and I'm happy to guide anyone on how to do it. Or, funding would help a lot.

  3. juanpide commented on Apr 18, 2015

    @juanpide

    I agree, data.table is missing a fwrite functionality.
    It would be a great addition.

  4. minhhahl commented on May 8, 2015

    @minhhahl

    +1 for fwrite function

  5. stanasa commented on May 20, 2015

    @stanasa

    +1 for fwrite function

  6. danielsjf commented on Jun 24, 2015

    @danielsjf

    I would also really appreciate an fwrite function!

  7. MichaelChirico commented on Jul 8, 2015

    @MichaelChirico
    Member

    Of course I'm all in for this.

  8. arunsrinivasan commented on Jul 8, 2015

    @arunsrinivasan
    MemberAuthor

    At this point, as I briefly touched upon during UseR 2015, there's no motivation or incentive to implement fwrite for neither of us. To implement it efficiently is a lot of work, and it comes out of our free time. With the possibility of it being just reimplemented as well in another package (like readr) at some point in time, it doesn't seem like a good investment of our time.

    If anyone else is interested in investing their time, please feel free to contact us.

  9. oseiskar commented on Oct 1, 2015

    @oseiskar
    Contributor

    We have developed a faster function for writing CSV files and achieved > 2x speedups (on a 64-bit Windows machine with an SSD) See this Gist for a proof of concept. I can start working on a pull request with more features if you are interested.

  10. smartinsightsfromdata commented on Nov 3, 2015

    @smartinsightsfromdata

    @oseiskar code seems very promising.
    @mattdowle @arunsrinivasan would you consider a pr for a fwrite on this basis?

  11. Bohdan-Khomtchouk commented on Jan 31, 2016

    @Bohdan-Khomtchouk

    Not having fwrite to complement fread is like not having write.csv to complement read.csv (or write.table/read.table)

  12. migueltp commented on Mar 2, 2016

    @migueltp

    +1 for fwrite function

  13. julja commented on Mar 12, 2016

    @julja

    +1 for fwrite function

  14. mattdowle commented on Mar 24, 2016

    @mattdowle
    Member

    @oseiskar @smartinsightsfromdata Sorry I didn't see your comments above in Oct or Nov at the time. Of course (!) we would be delighted to accept PR. But I already wrote above in Oct 2014 that "Contributions are more than welcome" in case that was not already clear, so I don't know why you asked rather than just submitting the PR.
    Maybe it was because of our fears expressed above that the effort would be wasted. You may be better off contributing to the so called Hadley-verse since that is what most people (well, on twitter and blogs anyway) jump up and down about. Hadley has the midas touch if that's what you want. But if you wanted to contribute fwrite to data.table, of course it would be accepted. Or create your own new package of course.

  15. 18 remaining items

  16. mattdowle commented on Nov 18, 2016

    @mattdowle
    Member

    Work on fwrite continued here: #1664

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions