StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1965385
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2009-12-27T06:58:55.083
FavoriteCount
0
LastActivityDate
2009-12-27T06:58:55.083
LastEditDate
LastEditorUserId
0
OwnerUserId
119005
ParentId
1964999
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
<p>For large string, iterator is recommended for speed and low memory footprint.</p> <pre><code>import re, itertools # Original text text = "When in the course of human Events, it becomes necessary for one People to dissolve the Political Bands which have connected them with another, and to assume among the Powers of the Earth, the separate and equal Station to which the Laws of Nature and of Nature?s God entitle them, a decent Respect to the Opinions of Mankind requires that they should declare the causes which impel them to the Separation." n = 10 # An iterator which will extract words one by one from text when needed words = itertools.imap(lambda m:m.group(), re.finditer(r'\w+', text)) # The final iterator that combines words into n-length groups word_groups = itertools.izip_longest(*(words,)*n) for g in word_groups: print g </code></pre> <p>will get the following result:</p> <pre><code>('When', 'in', 'the', 'course', 'of', 'human', 'Events', 'it', 'becomes', 'necessary') ('for', 'one', 'People', 'to', 'dissolve', 'the', 'Political', 'Bands', 'which', 'have') ('connected', 'them', 'with', 'another', 'and', 'to', 'assume', 'among', 'the', 'Powers') ('of', 'the', 'Earth', 'the', 'separate', 'and', 'equal', 'Station', 'to', 'which') ('the', 'Laws', 'of', 'Nature', 'and', 'of', 'Nature', 's', 'God', 'entitle') ('them', 'a', 'decent', 'Respect', 'to', 'the', 'Opinions', 'of', 'Mankind', 'requires') ('that', 'they', 'should', 'declare', 'the', 'causes', 'which', 'impel', 'them', 'to') ('the', 'Separation', None, None, None, None, None, None, None, None) </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSplit a large string into multiple substrings containing 'n' number of words via python
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USiamamac
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COThen I stick the words in each group tuple together with spaces?
  singulars
  PostPostId
  PO
  UserUserId
  UStorger
2. COYes, just use print ' '.join(g) instead of print g
  singulars
  PostPostId
  PO
  UserUserId
  USiamamac

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.