# -*- coding: utf-8 -*-
"""
Created on Tue Mar 24 12:47:41 2020

@author: user
"""


import numpy as np
import pandas as pd

# reading excel file with pandas
df = pd.read_excel (r'./Exemple1.xls') # df est de type dataframe
df

df = pd.read_excel (r'./Exemple1.xls',index_col=0) #1ere col contient les noms d ech 
df


#get specific columns
Zn = pd.DataFrame(df, columns=['a','c']) # récupérer uniquement les deux colonnes ‘a’ et ‘c’

# reading CSV file with pandas
df = pd.read_csv (r'./Exemple2.csv',index_col=0)
shape = df.shape