Charles Kelly explains the automated method for creating tables within Jupyter notebooks.
- [Instructor] Creating tables within Markdown is not difficult but it can be tedious. You can use this link to navigate to a website that will create Markdown for tables that you create. For example, you can create a table in a spreadsheet or you can create a table from copying and pasting from a different website. In this video I'll create a table using Microsoft Excel. The table is included in the Excel file within your Begin file folder.
After you open the file click on the cell that says Type and highlight all the information down to and including the cell that includes difference between two daytime values. Copy this information then navigate back to the webpage that will create the Markdown for us. Place your cursor into the sample table and type Control + V. Next, press the Generate button. You'll see this is the Markdown code that is created.
Click the button that says Copy to Clipboard and then go back to the Begin file folder with Markdown Tables. Press Control + V. This inserts the information into the cell. Press Esc + M to convert it to a Markdown cell and finally, type Shift + Enter and see the results of the table. This site is both well engineered and well designed. It is well engineered in the sense that it creates a useful and a predictable result, that's the code for the Markdown.
It's well designed in a sense that I did not have to read any documentation other than what's on the page to understand how to use the table generator. I hope that you find this website useful in your own work.
Watch this course to gain an overview of pandas. Charles Kelly helps you get started with time series, data frames, panels, plotting, and visualization. All you need is a copy of the free and interactive Jupyter Notebook app to practice and follow along.
- Using the Markdown language and Jupyter Notebook
- Creating objects
- Selecting objects
- Using operations
- Merging data
- Creating series
- Creating data frames
- Creating panels
- Annotating plots and data frame plots