Hi there ,
Earlier i had sent an email on how to use re.sub function to eliminate
square brackets. I have simplified the statements. Attached txt file named
unon.Txt has the data im extracting from. The file named code.txt has the
codes I'm using to extract the data.The regular expression works fine but
my output has too many square brackets. How do i do away with them thanks.
Regards,
Kanja Edward.
P.O.BOX 1203-00300,
NAIROBI.
*+254720724793*
www.linkedin.com/in/edward-kanja-bba16a106 <http://linkeldin/>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Rawzeea NLKPP | VE11-Nairobi
| 20002254-MADIZ | 00 | 00
|Regular Scheme B | 15-JAN-2019 To 31-DEC-2019 | No |
|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 11113648 | 18-FEB-2020 | Yes | 03
| 0000.00 USD | 0.00 USD | Leased Commercially
| 000000.00 KES | No |
|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| R-9-01 | 00.00% |0023.28 KES |000.18 USD
| | 1.00000 | 0.00 | 0.00 | No
| 10-JAN-2019 To 31-DEC-2019 |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Valid From: 17-Jan-2017
| Warwass Center
|
| Warwass Center
| UK-8
|
|
| UK Avenue
|
| Nairobi---Kenya
|
|
|
| Nairobi--00100-Kenya
|
|
| 0207690606
|
|
| hous...@weekly.com
|
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Pattly MUNIIZ | TX00-Nairobi
| 20000006-KZAU | 00 | 00
|Regular Scheme B | 05-JAN-2010 To 01-JAN-2019 | No |
|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 10000007 | 07-DEC-2019 | No | 00
| 0000.00 USD | 0.00 USD | Leased Commercially
| 000000.00 KES | No |
|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| K-3-10 | 00.00% |0000.25 KES |0000.60 USD
| | 1.00000 | 0.00 | 0.00 | No
| 01-JAN-2019 To 01-JAN-2000 |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Valid From: 65-Feb-2010
| Kuthat Skuh
|
| 98 Runka road
| 98
|
|
| Runka Road
|
| Nairobi---Kenya
|
|
|
| Nairobi--00200-Kenya
|
|
|
|
|
|
|
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
import pandas as pd
from pandas import DataFrame #creating my dataframes manually.
import re
#import textfile
with open ('unon.txt') as csvfile:
mydata=pd.read_csv('unon.txt')
for line in csvfile:
index_no=re.findall(r'(\|\s\d{5,8}\s)',line)
names=re.findall(r'(\|[A-Za-z]\w*\s\w*\s\w*\s\w*\s)',line)
#Address=re.findall(r'\|\s([A-Z0-9-,/]\w*\s\w*\s)',line)
duty_station=re.findall(r'\|\s[A-Z]*\d{2}\-\w\w\w\w\w\w\w\s',line)
print((index_no),(names),(duty_station))_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
