Data analysis – Export file data

Create

Create a directory in the desktop and name it «Export_File_Data»

Set the file: Excel-01-data.xlsx

In Jupiter within «Export_File_Data» directory and create a new python file.

Add the next code:

import pandas as pd	
	
archivo = pd.ExcelFile('CExcel10-01-Python')	
	
df=pd.read_excel(archivo, sheet_name = "datos")	
	
	
import pandas as pd	
import numpy as np	
import matplotlib.pyplot as plt	
	
archivo = "CExcel10-01-Python.xlsx"	
	
dfdatos = pd.read_excel(archivo, sheet_name="datos")	
	
dfdatos.head()	

After run the code, we achieve this new excel file. It includes total of expenses and incomes.