6 ms·

Show HN: Tably – Python script for converting .csv to LaTeX tables

57 points by narimiran 9y ago

narimiran 9y ago
I know this is very basic and not comparable with most of the stuff posted here, but anyway... If you have some feature suggestion, bug report, or some general (coding) advice, please let me know. Thank you in advance!
- bflesch 9y ago
  Thank you, this looks very useful to me. Saying that as someone who has spent several hours converting csv data to latex tables in the past ;)
  - narimiran 9y ago
    > Thank you, this looks very useful to me. I'm glad to hear that! :) > someone who has spent several hours converting csv data to latex tables in the past Hopefully, tably will save you some hours in the future. If you find anything that could be improved, contact me and I'll see what I can do about it.
cup-of-tea 9y ago
Why? Is CSV easier to write than LaTeX? I prefer something like org-mode tables which are actually easy to write.
- deleted 9y ago
  [deleted]
- narimiran 9y ago
  > Why? Is CSV easier to write than LaTeX? 1. When it comes to tables, yes - CSV is easier to write than LaTeX. Everything is easier than LaTeX tables :) 2. More serious reason - I have some lab equipment which outputs its results as CSV files, so this tool is used to convert those 'automatically' created .csv files.
  - cup-of-tea 9y ago
    But isn't it just a character substitution? TeX uses & and \\ for column and row separators, CSV uses , and newline. There's no way I'm writing either of them by hand, so why do I need to convert from CSV?
lorey 9y ago
If you have pandas installed, you can also use something like: pd.DataFrame.from_csv(path_csv).to_latex(path_latex) More information at http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_latex.html http://pandas.pydata.org/pandas-docs/stable/generated/pandas...
- narimiran 9y ago
  > If you have pandas installed, ... I'll just copy my Reddit comment when somebody notified me about `to_latex()`: > To be honest, I didn't know this exists (and I use pandas for lots of things). If I did, I probably wouldn't even start making tably. > Thanks for letting me know about it, I might use it as an inspiration to maybe add some more functionality in the future....
deleted 9y ago
[deleted]
gregod 9y ago
If you have the csvsimple [1] latex package available this can be done as latex macro. This allows for easy integration with other latex packages (drawing stuff with tikz for example [2]). Python and a makefile might perform better for larger data sets though. [1] https://ctan.org/pkg/csvsimple https://ctan.org/pkg/csvsimple [2] http://www.godberit.de/2016/01/31/Keeping-documentation-up-to-date-using-LaTeX-and-Tikz.html http://www.godberit.de/2016/01/31/Keeping-documentation-up-t...
deleted 9y ago
[deleted]
tmalsburg2 9y ago
In R: read_csv("file.csv") %>% xtable p.s: I don't want to suggest the the Python program is inferior. This is just an illustration showing how easy it is to manipulate table data in R. R is basically a language designed for that purpose.
- _Wintermute 9y ago
  about as easy in python: pd.read_csv("file.csv").to_latex()
horatatata 9y ago
either way! im going to use Latex tables more because they are so easy and so damn good lookin'
fiatjaf 9y ago
See also http://stevecat.net/table-magic/ http://stevecat.net/table-magic/ for in-browser table conversion between CSV/TSV, HTML, Markdown, SQL (the output format) and an editable table-form.

57 points by narimiran 9y ago

I know this is very basic and not comparable with most of the stuff posted here, but anyway... If you have some feature suggestion, bug report, or some general (coding) advice, please let me know. Thank you in advance!

bflesch 9y ago
Thank you, this looks very useful to me. Saying that as someone who has spent several hours converting csv data to latex tables in the past ;)
- narimiran 9y ago
  > Thank you, this looks very useful to me. I'm glad to hear that! :) > someone who has spent several hours converting csv data to latex tables in the past Hopefully, tably will save you some hours in the future. If you find anything that could be improved, contact me and I'll see what I can do about it.

cup-of-tea 9y ago

Why? Is CSV easier to write than LaTeX? I prefer something like org-mode tables which are actually easy to write.

deleted 9y ago
[deleted]
narimiran 9y ago
> Why? Is CSV easier to write than LaTeX? 1. When it comes to tables, yes - CSV is easier to write than LaTeX. Everything is easier than LaTeX tables :) 2. More serious reason - I have some lab equipment which outputs its results as CSV files, so this tool is used to convert those 'automatically' created .csv files.
- cup-of-tea 9y ago
  But isn't it just a character substitution? TeX uses & and \\ for column and row separators, CSV uses , and newline. There's no way I'm writing either of them by hand, so why do I need to convert from CSV?

lorey 9y ago

If you have pandas installed, you can also use something like: pd.DataFrame.from_csv(path_csv).to_latex(path_latex) More information at http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_latex.html http://pandas.pydata.org/pandas-docs/stable/generated/pandas...

narimiran 9y ago
> If you have pandas installed, ... I'll just copy my Reddit comment when somebody notified me about `to_latex()`: > To be honest, I didn't know this exists (and I use pandas for lots of things). If I did, I probably wouldn't even start making tably. > Thanks for letting me know about it, I might use it as an inspiration to maybe add some more functionality in the future....

deleted 9y ago

[deleted]

gregod 9y ago

If you have the csvsimple [1] latex package available this can be done as latex macro. This allows for easy integration with other latex packages (drawing stuff with tikz for example [2]). Python and a makefile might perform better for larger data sets though. [1] https://ctan.org/pkg/csvsimple https://ctan.org/pkg/csvsimple [2] http://www.godberit.de/2016/01/31/Keeping-documentation-up-to-date-using-LaTeX-and-Tikz.html http://www.godberit.de/2016/01/31/Keeping-documentation-up-t...

deleted 9y ago

[deleted]

tmalsburg2 9y ago

In R: read_csv("file.csv") %>% xtable p.s: I don't want to suggest the the Python program is inferior. This is just an illustration showing how easy it is to manipulate table data in R. R is basically a language designed for that purpose.

_Wintermute 9y ago
about as easy in python: pd.read_csv("file.csv").to_latex()

horatatata 9y ago

either way! im going to use Latex tables more because they are so easy and so damn good lookin'

fiatjaf 9y ago

See also http://stevecat.net/table-magic/ http://stevecat.net/table-magic/ for in-browser table conversion between CSV/TSV, HTML, Markdown, SQL (the output format) and an editable table-form.