0

I encountered a fairly common problem at work, for which I decided to write a seemingly simple code, I need from a text file where cities with routing numbers are written.

the data looks like this

62422 Prague 65233 London 64223 Kutná Hora 43356 Hradec Králové 63212 Brno

I need to use the pandas library, if possible, I get this data in one column and I need to divide it into two columns, where the postal code will be written in one and the name of the city, London or Kutná Hora in the other

could someone give me some advice, thank you very much

Felin
  • 1
  • just use `pd.read_table('file.txt', header = None, sep ='(?<=\\d) (?=\\D)', engine = 'python')` – Onyambu Oct 18 '22 at 20:29

0 Answers0