Python parse text question

ArthurHuang · 03-08-2012, 11:14 AM

Hi there, I am quite new to python; I usually use C/C++ to do the following job,but it looks more and more tedious.
I want to learn python by this try out, please help.

I want to convert the following format:

Key1 Key2 key3
1 2 3
3 2 4
2 2 3
Duplicated Key1 Duplicated Key1 Duplicated Key1
5 2 5
4 2 5
...
...

To a clean format:

Key1 Key2

1 2

2 2

3 2

4 2

5 2
....
....

There are 3 things need to implement:
1) Remove the duplicated key1, key2, key3 in the middle of text.
2) Truncate the key3 column.
3) Sort the whole file by key1

How can I make it? Thanks a lot!

thanks a lot!

grail · 03-08-2012, 11:44 AM

What have you tried? Python is an extensive language and a simple google will show a plethora of examples and tutorials.

graemef · 03-08-2012, 11:29 PM

check the CSV file reading function. You can use that to get your data into a list and then you can manipulate the list to get the data into the format that you require.

dugan · 03-08-2012, 11:40 PM

Quote:

Originally Posted by ArthurHuang

1) Remove the duplicated key1, key2, key3 in the middle of text.

This is the easiest way to remove duplicates:

Code:

>>>list(set([1, 2, 2]))
[1, 2]

Quote:

2) Truncate the key3 column.

Code:

>>>[1, 2, 3][:-1]
[1, 2]

Quote:

3) Sort the whole file by key1

After parsing the file into a list of lists or a list of tuples:

Code:

>>>>sorted([[1, 2, 3], [3, 2, 1], [2, 3, 1]], key=lambda x: x[0])
[[1, 2, 3], [2, 3, 1], [3, 2, 1]]