It seems you have a copy-paste error here, as you just have to change the 6 to 4 when you do the slice. Also note that you use two different lists for the range and for the slice. I think you meant this:

for d in range(0,len(codedmessage),4):
    codewordgrid.append(list(codedmessage[d:d+4]))

You are first adding R0Cx and then R1Cxy. You need to add RxCy. So try:

newlist = []
row = A
col = B
for x in range (0, row): 
  newlist.append([])

  for y in range(0, col):
    newlist[x].append('R' + str(x) + 'C' + str(y))

print(newlist)

Use re.split() to use multiple delimiters as the field delimiters in your lines.

Use a list slice to discard the third field if it exists.

Use a list comprehension to convert all the fields to numbers.

import re

with open("tester2.txt") as f:
    lines = [line.strip() for line in f.readlines()]

for i, line in enumerate(lines):
    lines[i] = [int(num) for num in re.split(r'[\s.,;]', line)[:2]]

print(lines)

The Answer(s)

Using Python 2.x it's as simple as

list_of_lists = [map(int,l.split()) for l in open('data.txt').readlines()]

but for Python 3.x the map builtin returns a generator, not a list so it has to be written using list comprehension (LC)

lol = [[int(s) for s in l.split()] for l in open('data.txt').readlines()]

BTW, the second possibility works as well in Python 2.x, so from a compatibility POV it could be the preferred approach.

Why does it works?

Let's focus on the second answer, our list of lists (LOL) is built using a nested list comprehension, the outer producing a list of objects produced by the inner one, i.e., lists, hence a LOL as requested...

The fundamental concept is that you need not an explicit loop on the lines of a file because every file object, as returned from the open builtin, has a .readlines method that returns a list of lines, each line represented by a string terminated by the linefeed character.

The elements of this list (the lines) can be split in individual elements using the .split method of strings --- by default split acts on whitespace, so it follows your requirements and we can write, using a LC

[l.split() for l in open('data.txt').readlines()]

obtaining the following LOL

[['1', '2', '3'], ['4', '5', '6'], ['7', '8', '9']],

as you can see we are close to our target, but the elements of the inner lists are not numbers, but textual repersentations of numbers, i.e., strings.

We have to introduce a further step, that is converting strings to numbers. We have two choices, the builtins int and float, in your case it seems that you want integers so we want int, a function that accepts a single argument (that's not exactly true) either a number or a string.

If we pass to int the outcome of l.split() an error will be raised, because l.split() doesn't return a string but a list of strings... we have to 1. unpack the elements of the lists and 2. pack back the results into a list, in other words it is again a LC!

[int(s) for s in l.split()] # -> [1, 2, 3] for the first line, etc

Let's put the pieces together and you have your answer:

lol = [[int(s) for s in l.split()] for l in open('data.txt').readlines()]

It's really easy (if you already knew all the stuff I tried to explain, that is...)

This should work. df.index.values This returns index in the form of numpy array numpy.ndarray, run this type(df.index.values) to check.

You can use:

df = pd.DataFrame([A])
print (df)
   0  1  2    3 4
0  1  d  p  bab  

If all values are strings:

df = pd.DataFrame(np.array(A).reshape(-1,len(A)))
print (df)

   0  1  2    3 4
0  1  d  p  bab  

Thank you AKS:

df = pd.DataFrame(A).T
print (df)
   0  1  2    3 4
0  1  d  p  bab  

Just check the first index:

def num_rows(group):
    return len(group)

def num_columns(group):
    return len(group[0])

Take in mind this will raise an IndexError exception if there's no rows.