{"id":1039,"date":"2016-02-18T16:00:40","date_gmt":"2016-02-18T16:00:40","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/?p=1039"},"modified":"2016-02-18T16:01:17","modified_gmt":"2016-02-18T16:01:17","slug":"python-tables","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/2016\/02\/18\/python-tables\/","title":{"rendered":"Python Tables"},"content":{"rendered":"

\"table\"<\/a>I was asked in class how we can create a table in Python. There are a number of ways to do this but the easiest is probably to use the .format method<\/a>.<\/p>\n

The program reads in data from a CSV file before displaying the information in a two column table. There is a lot of internal commentary you can strip out leaving just the code.<\/p>\n

The main part of the program is line 28. Where the contents of names and scores are displayed one line at a time with padding to make them appear to be in a table.<\/p>\n

<\/p>\n

\n\n\n\n
\n
 1\r\n 2\r\n 3\r\n 4\r\n 5\r\n 6\r\n 7\r\n 8\r\n 9\r\n10\r\n11\r\n12\r\n13\r\n14\r\n15\r\n16\r\n17\r\n18\r\n19\r\n20\r\n21\r\n22\r\n23\r\n24\r\n25\r\n26\r\n27\r\n28\r\n29<\/pre>\n<\/td>\n
\n
#Read in 10 sets of data from a CSV File<\/span>\r\n\r\nnames=<\/span>[\"\"<\/span>]*<\/span>10<\/span>\r\nscores=<\/span>[0<\/span>]*<\/span>10<\/span>\r\ncsv_file =<\/span> open<\/span>('highscores.csv'<\/span>,'r'<\/span>)   # 1. Open file<\/span>\r\nfor<\/span> index in<\/span> range<\/span>(10<\/span>):                 # 2. read data from file<\/span>\r\n    names[index],scores[index]=<\/span>csv_file.<\/span>readline()[:-<\/span>1<\/span>].<\/span>split(','<\/span>)     # split into two variables after removing newline<\/span>\r\n    scores[index]=<\/span>int<\/span>(scores[index])    # change score to Integer<\/span>\r\ncsv_file.<\/span>close()                        # 3. close file<\/span>\r\n\r\n# Using format method to justify the coloumns<\/span>\r\n# .format is used to change the format of a string<\/span>\r\n# eg.    '{:<5}{:>10}'.format('Name','Score')<\/span>\r\n#          1st   2nd            1st    2nd<\/span>\r\n# < left align<\/span>\r\n# > right align<\/span>\r\n# ^ centre align<\/span>\r\n# the number is the size the string is padded too<\/span>\r\n# the above example would create a string like the one below A is used for a 1st, B for 2nd<\/span>\r\n# AAAAABBBBBBBBBB<\/span>\r\n# so Dan and 2343 would give<\/span>\r\n# DanAABBBBBB2343 where AABBBBBB would be spaces<\/span>\r\n\r\nprint<\/span>('{:*^15}'<\/span>.<\/span>format('High Scores'<\/span>)) # The * is used instead of spaces for padding<\/span>\r\nprint<\/span>('-'<\/span>*<\/span>15<\/span>) # 15 dashes<\/span>\r\nprint<\/span>('{:<5}{:>10}'<\/span>.<\/span>format('Name'<\/span>,'Score'<\/span>)) # Print the headings (outside of loop)<\/span>\r\nfor<\/span> index in<\/span> range<\/span>(10<\/span>):\r\n    print<\/span>('{:<5}{:>10}'<\/span>.<\/span>format(names[index],scores[index])) # display each line<\/span>\r\n    \r\n<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
I was asked in class how we can create a table in Python. There are a number of ways to do this but the easiest is probably to use the .format method. The program reads in data from a CSV file before displaying the information in a two column table. There is a lot of …<\/p>\n","protected":false},"author":32,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17935,17932,17009],"tags":[125745,446],"class_list":["post-1039","post","type-post","status-publish","format-standard","hentry","category-algorithm-specification","category-computational-constructs","category-software-design-devlopment","tag-csv","tag-format"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/comments?post=1039"}],"version-history":[{"count":3,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1039\/revisions"}],"predecessor-version":[{"id":1043,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/posts\/1039\/revisions\/1043"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/media?parent=1039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/categories?post=1039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/nl\/ColtnessHS-ComputingScience\/wp-json\/wp\/v2\/tags?post=1039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}