What Markdown is
A Markdown table is rows of pipe-separated cells with a dashed rule under the header. Alignment is set by placing colons in that rule.
README files, GitHub issues, documentation sites, Obsidian and Notion.
What Pandas DataFrame is
Python that builds a pandas DataFrame from a dictionary of columns.
Data analysis and notebooks.
What changes when you convert Markdown to Pandas DataFrame
Leading and trailing pipes are optional and both are handled. A pipe the author escaped with a backslash is read as data rather than a column break, which is the usual reason a hand-written table parses one column too wide.
The import line is included so the snippet runs as is. Turn type inference on and numeric columns arrive as numbers rather than strings, which is usually what you want in a DataFrame.
What carries over from Markdown to Pandas DataFrame
One property of the Markdown has no home in pandas, and it is worth knowing which before you convert.
pandas wants a type for each column, and Markdown does not record one, so each column is typed from what its values look like. A column of digits that should stay text - a zip code, a phone number, a leading-zero id - is the usual thing to check afterwards.
Anything visual in the Markdown - weight, alignment, colour, column widths - has no counterpart in pandas and is dropped. The values are what survives.
The identifier 007 comes out of the Pandas DataFrame as 007. Reading it as a number would have made it 7, and an id that changes value is worse than one that stays text.
The role "Analyst, data" survives with its comma, in one cell rather than split across two. That is the first thing to check in any converted table, and the usual place a Pandas DataFrame file goes wrong.
The quotes around Jonah "Jo" Pryce are escaped with a backslash in the Pandas DataFrame.