To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/GavinFreeborn . You’ll also get 20% off an annual premium subscription.
Quick corrections. I realized that you can simply use `#+NAME:` in all cases. no need to use #`+TBLNAME:` . The reason I used :export both was for use with org export. I should have removed that from the version used in this video.
This is a great video! it comes into my mind that you may want to make a similar one for org-babel, and how to extend or modify them. Thanks for great video again 🙂
Great video! I would love to see another one of your own personal workflow and how you use orgmode to manage personal stuff like finances and synching tasks/calendar with your phone. Also, maybe how you use it for work projects, project management, and team communication.
Tables are great, especially if you write technical documents. One suggestion: the theme you're using has very low contrast on brackets and parentheses. Some of us have a hard time seeing that (vision degrades with age, it sucks) - I had to fullscreen the video to see them. It's a pity 'cause that's a very pretty color scheme.
Outstanding video thanks! I have been getting more into tables and lately writing an exporter. Tony Aldon's series on tables is also excellent and covers different material.
I really appreciate your videos. Very organized, and I like that you publish your source files. (also, somehow your emacs seem to be much faster than mine 😅
I like your color scheme, it's very readable, what is it? This was useful video for me, even though I fell asleep at some point due to unrelated reasons, as I use org-mode tables to write down financial stuff but my spreadsheet skills in emacs are still somewhat lacking. Need to rewatch this with more fresh eyes.
*Abstract* This video dives deep into the powerful table functionality of Org-mode. While basic table creation and editing are covered, the focus is on advanced features that transform tables into spreadsheets, time trackers, and even programming tools. Learn how to perform calculations, reference other tables, and leverage interpreters to analyze and visualize data directly within your Org files. *Summary:* *Creating and Editing Tables:* - 0:57: Initialize tables with a horizontal bar and use tab to navigate and enter data. - 2:27: Create headers by adding a vertical bar and tab. - 2:47: Use shift and arrow keys to move table fields. - 3:04: Use meta and arrow keys to move entire rows and columns. - 3:11: Use shift+meta with up/down arrows to delete/add rows and columns. - 3:46: Select rectangular regions with ctrl+space and copy/paste with ctrl+c, ctrl+x, and ctrl+y or alt+w. *Generating Tables:* - 4:56: Convert comma or tab-separated data into tables with ctrl+vertical bar. - 5:29: Import tables from CSV or TSV files with alt+x table-import. *Calculations and References:* - 6:11: Enter calculations for entire columns with ctrl+c =. - 6:51: Enter calculations for specific fields with ctrl+u ctrl+c =. - 7:43: Reference other table cells with @ for rows and $ for columns. - 8:04: Use modifiers like > and .. to reference specific elements and ranges. - 9:51: Use := for quick shorthand calculations within tables. - 10:36: Reference data from other tables with remote. *Advanced Features with Org Babel:* - 12:07: Execute code blocks within Org files using Org Babel. - 12:21: Generate data and results directly in tables. - 15:33: Use tables as input for code blocks to filter and analyze data. - 16:45: Leverage R and other languages for advanced statistical analysis and visualization. *Conclusion:* - 18:26: Org-mode tables offer powerful tools for automating tasks, performing calculations, and analyzing data. disclaimer: i used gemini 1.5 pro to summarize the youtube transcript.
"calc, it can generate Taylor Series for you" ... 10 seconds later ... "so when calc isn't enough for you . . .", I guess for those of us that are solving the Riemann Hypothesis in emacs, likely with something like M-x prove-langlands
To try everything Brilliant has to offer-free-for a full 30 days, visit brilliant.org/GavinFreeborn . You’ll also get 20% off an annual premium subscription.
Quick corrections. I realized that you can simply use `#+NAME:` in all cases. no need to use #`+TBLNAME:` . The reason I used :export both was for use with org export. I should have removed that from the version used in this video.
You can put :exports both into :header-args: of the document.
my man didnt stop using emacs or lisp 💥
Nice! I explained tables in Org-mode in class when explaining shell expansion and this video come just in time.
This is a great video! it comes into my mind that you may want to make a similar one for org-babel, and how to extend or modify them.
Thanks for great video again 🙂
Great video! I would love to see another one of your own personal workflow and how you use orgmode to manage personal stuff like finances and synching tasks/calendar with your phone. Also, maybe how you use it for work projects, project management, and team communication.
The sqlite example at the end was the cherry on top of an already awesome vid.
Tables are great, especially if you write technical documents.
One suggestion: the theme you're using has very low contrast on brackets and parentheses. Some of us have a hard time seeing that (vision degrades with age, it sucks) - I had to fullscreen the video to see them. It's a pity 'cause that's a very pretty color scheme.
Thanks for sharing I will startt disabling parenface when recording.
Outstanding video thanks! I have been getting more into tables and lately writing an exporter. Tony Aldon's series on tables is also excellent and covers different material.
I really appreciate your videos. Very organized, and I like that you publish your source files. (also, somehow your emacs seem to be much faster than mine 😅
Wait till you discover column view!
I like your color scheme, it's very readable, what is it?
This was useful video for me, even though I fell asleep at some point due to unrelated reasons, as I use org-mode tables to write down financial stuff but my spreadsheet skills in emacs are still somewhat lacking.
Need to rewatch this with more fresh eyes.
*Abstract*
This video dives deep into the powerful table functionality of
Org-mode. While basic table creation and editing are covered, the
focus is on advanced features that transform tables into spreadsheets,
time trackers, and even programming tools. Learn how to perform
calculations, reference other tables, and leverage interpreters to
analyze and visualize data directly within your Org files.
*Summary:*
*Creating and Editing Tables:*
- 0:57: Initialize tables with a horizontal bar and use tab to navigate and enter data.
- 2:27: Create headers by adding a vertical bar and tab.
- 2:47: Use shift and arrow keys to move table fields.
- 3:04: Use meta and arrow keys to move entire rows and columns.
- 3:11: Use shift+meta with up/down arrows to delete/add rows and columns.
- 3:46: Select rectangular regions with ctrl+space and copy/paste with ctrl+c, ctrl+x, and ctrl+y or alt+w.
*Generating Tables:*
- 4:56: Convert comma or tab-separated data into tables with ctrl+vertical bar.
- 5:29: Import tables from CSV or TSV files with alt+x table-import.
*Calculations and References:*
- 6:11: Enter calculations for entire columns with ctrl+c =.
- 6:51: Enter calculations for specific fields with ctrl+u ctrl+c =.
- 7:43: Reference other table cells with @ for rows and $ for columns.
- 8:04: Use modifiers like > and .. to reference specific elements and ranges.
- 9:51: Use := for quick shorthand calculations within tables.
- 10:36: Reference data from other tables with remote.
*Advanced Features with Org Babel:*
- 12:07: Execute code blocks within Org files using Org Babel.
- 12:21: Generate data and results directly in tables.
- 15:33: Use tables as input for code blocks to filter and analyze data.
- 16:45: Leverage R and other languages for advanced statistical analysis and visualization.
*Conclusion:*
- 18:26: Org-mode tables offer powerful tools for automating tasks, performing calculations, and analyzing data.
disclaimer: i used gemini 1.5 pro to summarize the youtube transcript.
Thank you very much. I can't believe I forgot to add the show notes and time stamps 😅
Thanks for this video. It seems very useful.
Since everything is text-based, org tables + formulas also work well with git versioning.
"calc, it can generate Taylor Series for you" ... 10 seconds later ... "so when calc isn't enough for you . . .", I guess for those of us that are solving the Riemann Hypothesis in emacs, likely with something like M-x prove-langlands
nice man