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']
