1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
| import pandas as pd
import numpy as np
import xlsxwriter
from openpyxl import load_workbook
from pandas import ExcelWriter
from pandas import ExcelFile
data=pd.read_excel("site.xlsx","Feuille1", keep_default_na=False, skiprows = [0,1])
print(data)
totalballon=[]
b=[]
espece=np.where(data['Unnamed: 2']=='TOTAL Espèces')[0]
carte=np.where(data['Unnamed: 2']=='TOTAL CB')[0]
cheque=np.where(data['Unnamed: 2']=='TOTAL Chèque')[0]
articles=["Ballon bleu", "CH24 jaune", "Ballon rouge", "Chapeau", "Ballon vert", "Pantalon", "Fleurs"]
print(np.sum(data['Unnamed: 4'][espece]))
print(np.sum(data['Unnamed: 4'][carte]))
print(np.sum(data['Unnamed: 4'][cheque]))
for i in articles:
nb=np.where(data['Unnamed: 2']==i)[0]
b.append(np.sum(data['Unnamed: 1'][nb]))
print(b)
ballon=["Ballon bleu", "Ballon rouge", "Ballon vert"]
for j in ballon:
nb=np.where(data['Unnamed: 2']==j)[0]
totalballon.append(np.sum(data['Unnamed: 1'][nb]))
totalballon=[sum(totalballon)]
print(totalballon)
with pd.ExcelWriter('site.xlsx', engine='openpyxl') as writer:
writer.book = load_workbook('site.xlsx')
TOTALespece = np.sum(data['Unnamed: 4'][espece])
TOTALcarte = np.sum(data['Unnamed: 4'][carte])
TOTALcheque = np.sum(data['Unnamed: 4'][cheque])
df1 = pd.DataFrame({'articles':articles})
df2 = pd.DataFrame({'nombres':b})
df3 = pd.DataFrame({'Total ballon':totalballon})
dfe = pd.DataFrame({'TOTAL Espèces':[TOTALespece]})
dfcarte = pd.DataFrame({'TOTAL CB':[TOTALcarte]})
dfcheque = pd.DataFrame({'TOTAL Chèque':[TOTALcheque]})
df1.to_excel(writer, "Feuille2", index=False)
df2.to_excel(writer, "Feuille2", index=False, startcol=1)
df3.to_excel(writer, "Feuille2", index=False, startcol=2)
dfe.to_excel(writer, "Feuille2", index=False, startcol=3)
dfcarte.to_excel(writer, "Feuille2", index=False, startcol=4)
dfcheque.to_excel(writer, "Feuille2", index=False, startcol=5) |
