def main() : data = pd.read_exel('./Data/UAL_2015_to_2018.V2.xlsx') test = data.loc[data['Audit Year'] == 2018] test = test.drop(['Audit Year'], axis = 1) train
def chargement(link, table, names): print("Lectture des données") names = r_names(Liste_départements) date = parse_dates(Liste_départements) df = pd.read_exel(link, skiprows=[0, 1], header=None, names=Liste_départements, parses_date=date) df.to_sql(table, con=engine, if_exists='append, index = False') return print("Fin")
def chargement(link, table, names): print("Lectture des données") names = r_names(Population_France_par_commune) date = parse_dates(Population_France_par_commune) df = pd.read_exel(link, skiprows=[0, 1], header=None, names=Population_France_par_commune, parses_date=date) df.to_sql(table, con=engine, if_exists='append, index = False') return print("Fin")
import pandas as pd df = pd.read_csv("example.csv") print(df) print(df.head()) print(df.head(3)) print(df.tail(3)) df_excel = pd.read_exel("example.xls") df_delim = pd.read_csv('pokemon_data.txt', delimiter='\t') df['HP']