Apr-17-2021, 05:38 PM
Hope this helps
import pandas as pd url_ini = 'https://flightaware.com/live/fleet/' url_fim = '/cancelled' ncia = ['SKU', 'TAM'] for i in range(len(ncia)): url = url_ini + str(ncia[i]) + url_fim df = pd.read_html(url)[3] df.columns = df.columns.droplevel(0) df['Origin'] = df['Origin'].str.split('(').str[1].str[:3] df['Destination'] = df['Destination'].str.split('(').str[1].str[:3] df.to_csv(r'C:\Users\Kelum desktop PC\Desktop\Teste.txt', sep=';', mode='a', encoding = 'utf-8', index=False) print('Atualizado apra a ' + str(ncia[i]) )
Output:Ident;Type;Origin;Destination;ScheduledDeparture Time;Unnamed: 5_level_1;Unnamed: 6_level_1;Unnamed: 7_level_1
SKU329;A320;IQQ;SCL;Fri 08:47PM -04;;;
SKU253;A320;CJC;SCL;Fri 09:11PM -04;;;
SKU433;A320;SCL;PMC;Sat 10:55AM -04;;;
SKU433;A320;PMC;BBA;Sat 01:42PM -04;;;
SKU434;A320;BBA;PMC;Sat 03:40PM -04;;;
SKU434;A320;PMC;SCL;Sat 05:19PM -04;;;
SKU121;A320;SCL;ZAL;Sun 11:46AM -04;;;
SKU122;A320;ZAL;SCL;Sun 02:14PM -04;;;
SKU101;A320;SCL;ZOS;Sun 02:57PM -04;;;
SKU147;A320;SCL;ZCO;Sun 04:35PM -04;;;
SKU102;A320;ZOS;SCL;Sun 05:14PM -04;;;
SKU304;A320;SCL;ARI;Sun 05:30PM -04;;;
SKU148;A320;ZCO;SCL;Sun 06:30PM -04;;;
SKU326;A320;SCL;IQQ;Sun 06:47PM -04;;;
SKU163;A320;SCL;CCP;Sun 07:27PM -04;;;
Ident;Type;Origin;Destination;ScheduledDeparture Time;Unnamed: 5_level_1;Unnamed: 6_level_1;Unnamed: 7_level_1
TAM3595;A319;SDU;CGH;Sat 07:25AM -03;;;
TAM8146;B763;GRU;LIS;Sat 04:50PM -03;;;
TAM3585;A319;CGH;SDU;Sat 05:40PM -03;;;