{"id":1512,"date":"2025-06-04T07:11:25","date_gmt":"2025-06-04T07:11:25","guid":{"rendered":"https:\/\/learnlearn.uk\/python\/?page_id=1512"},"modified":"2025-06-05T09:45:42","modified_gmt":"2025-06-05T09:45:42","slug":"python-tables","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/python\/python-tables\/","title":{"rendered":"Python Tables"},"content":{"rendered":"
\n

Introduction<\/h2>\n
\n\n

Introduction<\/h3>\n

In programming, a table<\/strong> is a structured way to organize and display data in rows and columns\u2014just like a spreadsheet. Python doesn\u2019t have a built-in table data structure, but you can easily create and work with tables using lists, dictionaries, or third-party libraries like pandas<\/code><\/strong>, tabulate<\/code><\/strong>, or PrettyTable<\/code><\/strong>.<\/p>\n

A basic table<\/strong> in Python is often represented as a list of lists (for rows) or a list of dictionaries (for named columns).<\/p>\n

Example (List of Lists):<\/h4>\n
\n
# Headers<\/span>
\nheaders = [\"Name\"<\/span>, \"Age\"<\/span>, \"Grade\"<\/span>, \"Passed\"<\/span>]
\n<\/code><\/div>\n
# Rows<\/span>
\nrows = [
\n[\"Alice\"<\/span>, 14<\/span>, \"A\"<\/span>, \"Yes\"<\/span>],
\n[\"Bob\"<\/span>, 15<\/span>, \"B\"<\/span>, \"Yes\"<\/span>],
\n[\"Charlie\"<\/span>, 13<\/span>, \"C\"<\/span>, \"No\"<\/span>]
\n]
\n<\/code><\/div>\n<\/div>\n

This format allows us to print, sort, or manipulate tabular data programmatically.<\/p>\n

\n<\/div>

Advantages<\/h2>\n
\n<\/p>\n

Why Are Tables Useful?<\/h3>\n
    \n
  1. \n

    Organize Data Clearly<\/strong>
    Tables provide a clean, readable way to represent structured data, making it easier to understand and work with.<\/p>\n<\/li>\n

  2. \n

    Enable Data Analysis<\/strong>
    Tabular structures are essential in data analysis, where rows represent records and columns represent fields.<\/p>\n<\/li>\n

  3. \n

    Support Iteration and Automation<\/strong>
    Tables make it easy to loop through and process data row-by-row or column-by-column.<\/p>\n<\/li>\n

  4. \n

    Foundational for CSV and Excel Workflows<\/strong>
    Tables are the core structure used in CSV and Excel files\u2014both of which are commonly used for storing and sharing data.<\/p>\n<\/li>\n

  5. \n

    Useful for Display<\/strong>
    When printing data in reports, logs, or terminal UIs, tables make the output neat and easy to read.<\/p>\n<\/li>\n<\/ol>\n\n<\/div>

    Python Code<\/h2>\n
    \n\n

    Python Table Example Code<\/h3>\n
    # Define headers and rows\r\nheaders =<\/span> [<\/span>\"Name\"<\/span>,<\/span> \"Age\"<\/span>,<\/span> \"Grade\"<\/span>,<\/span> \"Passed\"<\/span>]<\/span>\r\nrows =<\/span> [<\/span>\r\n    [<\/span>\"Alice\"<\/span>,<\/span> 14<\/span>,<\/span> \"A\"<\/span>,<\/span> \"Yes\"<\/span>]<\/span>,<\/span>\r\n    [<\/span>\"Bob\"<\/span>,<\/span> 15<\/span>,<\/span> \"B\"<\/span>,<\/span> \"Yes\"<\/span>]<\/span>,<\/span>\r\n    [<\/span>\"Charlie\"<\/span>,<\/span> 13<\/span>,<\/span> \"C\"<\/span>,<\/span> \"No\"<\/span>]<\/span>\r\n]<\/span>\r\n\r\n# Print headers using f-<\/span>string\r\nprint<\/span>(<\/span>f\"{headers[0]:<10} {headers[1]:<5} {headers[2]:<7} {headers[3]:<7}\"<\/span>)<\/span>\r\n\r\n# Print separator line\r\nprint<\/span>(<\/span>\"-\"<\/span> *<\/span> 35<\/span>)<\/span>\r\n\r\n# Print each row using f-<\/span>string\r\nfor<\/span> row in<\/span> rows<\/span>:<\/span>\r\n    print<\/span>(<\/span>f\"{row[0]:<10} {row[1]:<5} {row[2]:<7} {row[3]:<7}\"<\/span>)<\/span>\r\nOutput<\/span>:<\/span>\r\nmarkdown\r\nCopy\r\nEdit\r\nName       Age   Grade   Passed \r\n--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>--<\/span>-<\/span>\r\nAlice      14<\/span>    A<\/span>       Yes    \r\nBob        15<\/span>    B<\/span>       Yes    \r\nCharlie    13<\/span>    C<\/span>       No     <\/code><\/pre>\n
    Key concepts<\/h3>\n
    “{:<10}” means left-align in a space of 10 characters.<\/p>\n
    *headers and *row unpacks the list into arguments for .format().<\/p>\n\n<\/div>
    Tutorial Video<\/h2>\n
    \n\n
    Tutorial Video<\/h3>\n
    \n
    https:\/\/www.youtube.com\/watch?v=RvqmZLuCQrw<\/a>