StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20469377
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
17
CommunityOwnedDate
CreationDate
2013-12-09T11:24:02.420
FavoriteCount
0
LastActivityDate
2013-12-09T20:23:45.473
LastEditDate
2013-12-09T20:23:45.473
LastEditorUserId
2208850
OwnerUserId
2208850
ParentId
20457832
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
EDIT: Ok, this is for your FIRST question. From what I understand, you are wanting a function that will return the number of cells in your table. This number does not include the names of people in the rows, and does not include the first row at all. If I understand correctly, then this should work: If table is: <pre><code>Name,Gender,Age,Salary,Height Menny, M, 1, 1, 1 James, J, 2, 2, 2 Sami, S, 3, 3, 3 </code></pre> Then number of cells is <code>'12'</code>... so: Example: <pre><code>class Table: def __init__(self, path, sep): try: with open(path) as f: read_file = f.read() # will auto close the file after the read except: print "cannot create a table from this file" return self.table = read_file.split('\n') # self.table will make this easier self.table = [self.table[i].split(sep) for i in range(len(self.table))] # does the same as your for loop if len(self.table) > 0: for i in range(len(self.table[0])): if self.table[0][i] in self.table[0][0:i]: raise ValueError row_names = [] for i in range(1,len(self.table)): if len(self.table[i]) != len(self.table[0]): raise ValueError if self.table[i][0] in row_names: raise ValueError row_names.append(self.table[i][0]) # now a function that could return the table length def get_num_cells(self): # essentially you sum each item in row[1:] for table[1:] return sum((sum(1 for i in range(1, len(self.table[0])))) for i in range(1,len(self.table))) </code></pre> Using <code>self.table</code> will make this easier, as you don't have to include it in the other function args, as above in <code>get_num_cells</code>, I just used <code>self.table</code> without putting it in the args of the function. To call this function you would do the following: <pre><code>app = Table(path, sep) app.get_num_cells() # this code would be placed at the end of your file, and not inside the class </code></pre> Example: <pre><code>class Table() __init__(self, path, sep): etc. etc.etc.etc. # now the code to create an instance of Table and call a method here like this app = Table(path, sep) # path would be a filepath "C:/etc./file.txt", and sep = "," etc. app.get_num_cells() </code></pre> For your other questions, I am not entirely sure what you want yet, but if you write again in the comments for this, I will try. Please let me know if this works for you.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POtables in python - having some errors - not sure why
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USTotem
UserOwnerUserId
1. USTotem
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. This table or related slice is empty.
CommentsPostId

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.