Splitting tabular data in python

Question

I've coded a program that gives me data in tabular form (using tabulate) in python:

from tabulate import tabulate

matrix=[[1,2,3,4],[5,6,7,8]]

print(tabulate(matrix))

It gives me this output:

Now say that I want to split this table in 2 such that it gives:

How would I do that?

Please take the [tour], read [what's on-topic here](/help/on-topic), [ask], and the [question checklist](//meta.stackoverflow.com/q/260648/843953), and provide a [mre]. "Implement this feature for me" is off-topic for this site. You have to _make an honest attempt_, and then ask a _specific question_ about your algorithm or technique. — Pranav Hosangadi, Nov 12 '20 at 20:50

Frederick · Answer 1 · 2020-11-12T20:46:37.253

0

Here is a function I found here to split a normal array into two arrays. In the for loop, we split every one of the arrays in the matrix with the function. When you want to get the first part change the 1 to a 0.

from tabulate import tabulate

def split_list(a_list):
    half = len(a_list)//2
    return a_list[:half], a_list[half:]

matrix=[[1,2,3,4],[5,6,7,8]]
new_matrix = []

for arr in matrix:
    new_matrix.append(split_list(arr)[1]) #Replace this 1 with a 0

print(tabulate(new_matrix))

or just

from tabulate import tabulate

def split_list(a_list):
    half = len(a_list)//2
    return a_list[:half], a_list[half:]

matrix=[[1,2,3,4],[5,6,7,8]]
new_matrix = split_list(matrix[1])


print(tabulate(new_matrix))

edited Nov 12 '20 at 20:46

answered Nov 12 '20 at 20:30

Frederick

452
4
19

Thank you for this answer, however I have to split the table directly not the list. – agg199 Nov 12 '20 at 20:35
why? you can save it in a variable and access it. – Frederick Nov 12 '20 at 20:38
You can also do it like this new_matrix = split_list(matrix[1]) without the for loop. Does this help? – Frederick Nov 12 '20 at 20:39
because it needs to be able to take in any tabular data, even the ones that aren't created using lists – agg199 Nov 12 '20 at 20:40
I am sorry I dont understand it could you give an example? Couldnt you convert the data to lists? The matrix is just a list in a list – Frederick Nov 12 '20 at 20:41
Yes, if I can convert the table to a list after the table is created I can use that, I can't modify the list before it is created into a table form however – agg199 Nov 12 '20 at 20:45
When you use those matrixes as tables then they are already lists – Frederick Nov 12 '20 at 20:47

Splitting tabular data in python

1 Answers1