Any library supports Guava tables to csv format?

Question

Are there any library supports Guava tables to csv format? I generated

RowSortedTable<String, String, Double> graph

But the generating process takes some time(some query processing is needed), so I want to save this intermediate result and want to read and use it again.

Apparently no built-in support for CSV serialization yet exists, even though [it has been requested](https://github.com/google/guava/issues/813). — Mick Mnemonic, Sep 23 '15 at 12:26
Solved this problem by using openCSV library. Thank you for all answers — SUNDONG, Sep 25 '15 at 01:04
@SUNDONG can you please post your solution? I have the same problem. — sinapan, Apr 30 '20 at 01:07
@sinapan Since the post is outdated, I couldn't remember the solution. Please refer to other answers, thanks! — SUNDONG, May 06 '20 at 05:26

user987541 · Accepted Answer · 2015-09-23T13:09:44.390

You can use Apache Commons CSV:

final RowSortedTable<String, String, Double> graph = TreeBasedTable.create();

graph.put("A", "0", 0.0);
graph.put("A", "1", 1.0);
graph.put("B", "0", 0.1);
graph.put("B", "1", 1.1);

final Appendable out = new StringBuilder();
try {
    final CSVPrinter printer = CSVFormat.DEFAULT.print(out);

    printer.printRecords(//
            graph.rowMap().values()//
                    .stream()//
                    .map(x -> x.values())//
                    .collect(Collectors.toList()));

} catch (final IOException e) {
    e.printStackTrace();
}

System.out.println(out);
// 0.0,1.0
// 0.1,1.1

this skips the first column though – LucasSeveryn Jul 22 '16 at 11:01 — LucasSeveryn, Jul 22 '16 at 11:01

score -3 · Answer 2 · answered Sep 23 '15 at 12:19

-3

To create a CSV file using Guava you can use Joiner.

  Joiner.on(",").join(yourStrings)

Try to drop the output of this utility into a file whith extension CSV.

answered Sep 23 '15 at 12:19

Nicolas Villavicencio

1
1
3

1

`Joiner.join` expects an `Iterable`, which I believe a Guava `Table` is not. You would need to retrieve a _view_ to the table cells and pass that to `join`. In any case, all of the elements would be output on the same row. – Mick Mnemonic Sep 23 '15 at 12:34
3

CSVs aren't quite this trivial. You need to handle escaping. – djechlin Jun 29 '16 at 20:47

Any library supports Guava tables to csv format?

2 Answers2