2018年销售汇总表-pandas数据分析

最新推荐文章于 2022-10-30 15:47:18 发布
最新推荐文章于 2022-10-30 15:47:18 发布
阅读量887 收藏 3
点赞数
原文链接：https://www.itcodemonkey.com/article/15554.html
版权 
import numpy as np
import pandas as pd
from sparklines import sparklines
df = pd.read_csv('2018年销售汇总表.csv',parse_dates = ['日期'],encoding="gbk")
df.head()# 查看前五条数据
t姓名单品数量单价金额日期
0740150Barton LLCB1-200003986.693380.912018-01-01 07:21:00
1714466Trantow-BarrowsS2-77896-163.16-63.162018-01-01 10:00:00
2218895Kulas IncB1-699242390.702086.102018-01-01 13:24:00
3307599Kassulke, Ondricka and MetzS1-654814121.05863.052018-01-01 15:05:00
4412290Jerde-HilpertS2-34077683.21499.262018-01-01 23:26:00
df.info()#显示数据基础信息

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 1500 entries, 0 to 1499
Data columns (total 7 columns):
t     1500 non-null int64
姓名    1500 non-null object
单品    1500 non-null object
数量    1500 non-null int64
单价    1500 non-null float64
金额    1500 non-null float64
日期    1500 non-null datetime64[ns]
dtypes: datetime64[ns](1), float64(2), int64(2), object(2)
memory usage: 82.2+ KB

# 讲解：按《姓名》分组，聚合《金额》的均值和总和
# 用法：按客人姓名查看消费金额的平均值与总金额
df.groupby("姓名")["金额"].agg(["mean","sum"])
meansum
姓名
Barton LLC1334.615854109438.50
Cronin, Oberbrunner and Spencer1339.32164289734.55
Frami, Hills and Schmidt1438.466528103569.59
Fritsch, Russel and Anderson1385.366790112214.71
Halvorson, Crona and Champlin1206.97172470004.36
Herman LLC1336.53225882865.00
Jerde-Hilpert1265.072247112591.43
Kassulke, Ondricka and Metz1350.79796986451.07
Keeling LLC1363.977027100934.30
Kiehn-Spinka1260.87050699608.77
Koepp Ltd1264.152927103660.54
Kuhn-Gusikowski1247.86684991094.28
Kulas Inc1461.191064137351.96
Pollich LLC1196.53671287347.18
Purdy-Kunde1469.77754777898.21
Sanford and Sons1391.87295898822.98
Stokes LLC1271.33222291535.92
Trantow-Barrows1312.567872123381.38
White-Trantow1579.558023135841.99
Will LLC1411.318919104437.60
# 讲解：在上一条命令中，并设置平均值与总金额的显示风格
# 用法：格式化数值，在前面添加美元符号，包括2位小数点
(
    df.groupby("姓名")["金额"]
    .agg(["mean","sum"])
    .style.format("${0:,.2f}")
)

            <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row0" class="row_heading level0 row0" >Barton LLC</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row0_col0" class="data row0 col0" >$1,334.62</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row0_col1" class="data row0 col1" >$109,438.50</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row1" class="row_heading level0 row1" >Cronin, Oberbrunner and Spencer</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row1_col0" class="data row1 col0" >$1,339.32</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row1_col1" class="data row1 col1" >$89,734.55</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row2" class="row_heading level0 row2" >Frami, Hills and Schmidt</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row2_col0" class="data row2 col0" >$1,438.47</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row2_col1" class="data row2 col1" >$103,569.59</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row3" class="row_heading level0 row3" >Fritsch, Russel and Anderson</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row3_col0" class="data row3 col0" >$1,385.37</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row3_col1" class="data row3 col1" >$112,214.71</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row4" class="row_heading level0 row4" >Halvorson, Crona and Champlin</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row4_col0" class="data row4 col0" >$1,206.97</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row4_col1" class="data row4 col1" >$70,004.36</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row5" class="row_heading level0 row5" >Herman LLC</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row5_col0" class="data row5 col0" >$1,336.53</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row5_col1" class="data row5 col1" >$82,865.00</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row6" class="row_heading level0 row6" >Jerde-Hilpert</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row6_col0" class="data row6 col0" >$1,265.07</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row6_col1" class="data row6 col1" >$112,591.43</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row7" class="row_heading level0 row7" >Kassulke, Ondricka and Metz</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row7_col0" class="data row7 col0" >$1,350.80</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row7_col1" class="data row7 col1" >$86,451.07</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row8" class="row_heading level0 row8" >Keeling LLC</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row8_col0" class="data row8 col0" >$1,363.98</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row8_col1" class="data row8 col1" >$100,934.30</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row9" class="row_heading level0 row9" >Kiehn-Spinka</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row9_col0" class="data row9 col0" >$1,260.87</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row9_col1" class="data row9 col1" >$99,608.77</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row10" class="row_heading level0 row10" >Koepp Ltd</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row10_col0" class="data row10 col0" >$1,264.15</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row10_col1" class="data row10 col1" >$103,660.54</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row11" class="row_heading level0 row11" >Kuhn-Gusikowski</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row11_col0" class="data row11 col0" >$1,247.87</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row11_col1" class="data row11 col1" >$91,094.28</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row12" class="row_heading level0 row12" >Kulas Inc</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row12_col0" class="data row12 col0" >$1,461.19</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row12_col1" class="data row12 col1" >$137,351.96</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row13" class="row_heading level0 row13" >Pollich LLC</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row13_col0" class="data row13 col0" >$1,196.54</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row13_col1" class="data row13 col1" >$87,347.18</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row14" class="row_heading level0 row14" >Purdy-Kunde</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row14_col0" class="data row14 col0" >$1,469.78</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row14_col1" class="data row14 col1" >$77,898.21</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row15" class="row_heading level0 row15" >Sanford and Sons</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row15_col0" class="data row15 col0" >$1,391.87</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row15_col1" class="data row15 col1" >$98,822.98</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row16" class="row_heading level0 row16" >Stokes LLC</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row16_col0" class="data row16 col0" >$1,271.33</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row16_col1" class="data row16 col1" >$91,535.92</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row17" class="row_heading level0 row17" >Trantow-Barrows</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row17_col0" class="data row17 col0" >$1,312.57</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row17_col1" class="data row17 col1" >$123,381.38</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row18" class="row_heading level0 row18" >White-Trantow</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row18_col0" class="data row18 col0" >$1,579.56</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row18_col1" class="data row18 col1" >$135,841.99</td>
        </tr>
        <tr>
                    <th id="T_2054f41e_2029_11ea_86d1_cc2f7187c201level0_row19" class="row_heading level0 row19" >Will LLC</th>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row19_col0" class="data row19 col0" >$1,411.32</td>
                    <td id="T_2054f41e_2029_11ea_86d1_cc2f7187c201row19_col1" class="data row19 col1" >$104,437.60</td>
        </tr>
</tbody></table>
meansum
姓名
# 平均值与总金额显示为不带小数点
(
    df.groupby("姓名")["金额"]
    .agg(["mean","sum"])
    .style.format("${0:,.0f}")
)

            <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row0" class="row_heading level0 row0" >Barton LLC</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row0_col0" class="data row0 col0" >$1,335</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row0_col1" class="data row0 col1" >$109,438</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row1" class="row_heading level0 row1" >Cronin, Oberbrunner and Spencer</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row1_col0" class="data row1 col0" >$1,339</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row1_col1" class="data row1 col1" >$89,735</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row2" class="row_heading level0 row2" >Frami, Hills and Schmidt</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row2_col0" class="data row2 col0" >$1,438</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row2_col1" class="data row2 col1" >$103,570</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row3" class="row_heading level0 row3" >Fritsch, Russel and Anderson</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row3_col0" class="data row3 col0" >$1,385</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row3_col1" class="data row3 col1" >$112,215</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row4" class="row_heading level0 row4" >Halvorson, Crona and Champlin</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row4_col0" class="data row4 col0" >$1,207</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row4_col1" class="data row4 col1" >$70,004</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row5" class="row_heading level0 row5" >Herman LLC</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row5_col0" class="data row5 col0" >$1,337</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row5_col1" class="data row5 col1" >$82,865</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row6" class="row_heading level0 row6" >Jerde-Hilpert</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row6_col0" class="data row6 col0" >$1,265</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row6_col1" class="data row6 col1" >$112,591</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row7" class="row_heading level0 row7" >Kassulke, Ondricka and Metz</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row7_col0" class="data row7 col0" >$1,351</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row7_col1" class="data row7 col1" >$86,451</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row8" class="row_heading level0 row8" >Keeling LLC</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row8_col0" class="data row8 col0" >$1,364</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row8_col1" class="data row8 col1" >$100,934</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row9" class="row_heading level0 row9" >Kiehn-Spinka</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row9_col0" class="data row9 col0" >$1,261</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row9_col1" class="data row9 col1" >$99,609</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row10" class="row_heading level0 row10" >Koepp Ltd</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row10_col0" class="data row10 col0" >$1,264</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row10_col1" class="data row10 col1" >$103,661</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row11" class="row_heading level0 row11" >Kuhn-Gusikowski</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row11_col0" class="data row11 col0" >$1,248</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row11_col1" class="data row11 col1" >$91,094</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row12" class="row_heading level0 row12" >Kulas Inc</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row12_col0" class="data row12 col0" >$1,461</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row12_col1" class="data row12 col1" >$137,352</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row13" class="row_heading level0 row13" >Pollich LLC</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row13_col0" class="data row13 col0" >$1,197</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row13_col1" class="data row13 col1" >$87,347</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row14" class="row_heading level0 row14" >Purdy-Kunde</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row14_col0" class="data row14 col0" >$1,470</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row14_col1" class="data row14 col1" >$77,898</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row15" class="row_heading level0 row15" >Sanford and Sons</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row15_col0" class="data row15 col0" >$1,392</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row15_col1" class="data row15 col1" >$98,823</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row16" class="row_heading level0 row16" >Stokes LLC</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row16_col0" class="data row16 col0" >$1,271</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row16_col1" class="data row16 col1" >$91,536</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row17" class="row_heading level0 row17" >Trantow-Barrows</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row17_col0" class="data row17 col0" >$1,313</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row17_col1" class="data row17 col1" >$123,381</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row18" class="row_heading level0 row18" >White-Trantow</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row18_col0" class="data row18 col0" >$1,580</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row18_col1" class="data row18 col1" >$135,842</td>
        </tr>
        <tr>
                    <th id="T_655533d8_2029_11ea_bc7d_cc2f7187c201level0_row19" class="row_heading level0 row19" >Will LLC</th>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row19_col0" class="data row19 col0" >$1,411</td>
                    <td id="T_655533d8_2029_11ea_bc7d_cc2f7187c201row19_col1" class="data row19 col1" >$104,438</td>
        </tr>
</tbody></table>
meansum
姓名
# 按月分析销售金额，并显示每月销售额占年度销售总额比例
by=[pd.Grouper(key='日期', freq='M')]#自定义字段的格式
monthly_sales=df.groupby(by)["金额"].agg(["sum"]).reset_index()
monthly_sales["月占比"]=monthly_sales["sum"]/df["金额"].sum()

format_dict = {'sum': '${0:,.0f}', '日期': '{:%Y-%m-%d}', '月占比': '{:.4%}'}
# 1.使用普通格式字典控制每列的格式
(
    monthly_sales
    .style
    .format(format_dict)
    .hide_index()
)


            <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row0_col0" class="data row0 col0" >2018-01-31</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row0_col1" class="data row0 col1" >$185,362</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row0_col2" class="data row0 col2" >9.1818%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row1_col0" class="data row1 col0" >2018-02-28</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row1_col1" class="data row1 col1" >$146,212</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row1_col2" class="data row1 col2" >7.2426%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row2_col0" class="data row2 col0" >2018-03-31</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row2_col1" class="data row2 col1" >$203,921</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row2_col2" class="data row2 col2" >10.1012%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row3_col0" class="data row3 col0" >2018-04-30</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row3_col1" class="data row3 col1" >$174,574</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row3_col2" class="data row3 col2" >8.6475%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row4_col0" class="data row4 col0" >2018-05-31</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row4_col1" class="data row4 col1" >$165,419</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row4_col2" class="data row4 col2" >8.1940%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row5_col0" class="data row5 col0" >2018-06-30</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row5_col1" class="data row5 col1" >$174,089</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row5_col2" class="data row5 col2" >8.6235%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row6_col0" class="data row6 col0" >2018-07-31</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row6_col1" class="data row6 col1" >$191,662</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row6_col2" class="data row6 col2" >9.4939%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row7_col0" class="data row7 col0" >2018-08-31</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row7_col1" class="data row7 col1" >$153,779</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row7_col2" class="data row7 col2" >7.6174%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row8_col0" class="data row8 col0" >2018-09-30</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row8_col1" class="data row8 col1" >$168,443</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row8_col2" class="data row8 col2" >8.3438%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row9_col0" class="data row9 col0" >2018-10-31</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row9_col1" class="data row9 col1" >$171,495</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row9_col2" class="data row9 col2" >8.4950%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row10_col0" class="data row10 col0" >2018-11-30</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row10_col1" class="data row10 col1" >$119,961</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row10_col2" class="data row10 col2" >5.9423%</td>
        </tr>
        <tr>
                            <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row11_col0" class="data row11 col0" >2018-12-31</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row11_col1" class="data row11 col1" >$163,867</td>
                    <td id="T_adf341e4_202d_11ea_af2c_cc2f7187c201row11_col2" class="data row11 col2" >8.1171%</td>
        </tr>
</tbody></table>
日期sum月占比
# 按月分析销售金额，并显示每月销售额占年度销售总额比例
by=[pd.Grouper(key='日期', freq='M')]#自定义字段的格式
monthly_sales=df.groupby(by)["金额"].agg(["sum"]).reset_index()
monthly_sales["月占比"]=monthly_sales["sum"]/df["金额"].sum()

# 2.使用条件格式字典控制每列的格式
format_dict = {'sum': '${0:,.0f}', '日期': '{:%Y-%m-%d}', '月占比': '{:.4%}'}
(
    monthly_sales
    .style
    .format(format_dict)
    .hide_index()
    .highlight_max(color="lightgreen")
    .highlight_min(color="red")
)

            <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row0_col0" class="data row0 col0" >2018-01-31</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row0_col1" class="data row0 col1" >$185,362</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row0_col2" class="data row0 col2" >9.1818%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row1_col0" class="data row1 col0" >2018-02-28</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row1_col1" class="data row1 col1" >$146,212</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row1_col2" class="data row1 col2" >7.2426%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row2_col0" class="data row2 col0" >2018-03-31</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row2_col1" class="data row2 col1" >$203,921</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row2_col2" class="data row2 col2" >10.1012%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row3_col0" class="data row3 col0" >2018-04-30</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row3_col1" class="data row3 col1" >$174,574</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row3_col2" class="data row3 col2" >8.6475%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row4_col0" class="data row4 col0" >2018-05-31</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row4_col1" class="data row4 col1" >$165,419</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row4_col2" class="data row4 col2" >8.1940%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row5_col0" class="data row5 col0" >2018-06-30</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row5_col1" class="data row5 col1" >$174,089</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row5_col2" class="data row5 col2" >8.6235%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row6_col0" class="data row6 col0" >2018-07-31</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row6_col1" class="data row6 col1" >$191,662</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row6_col2" class="data row6 col2" >9.4939%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row7_col0" class="data row7 col0" >2018-08-31</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row7_col1" class="data row7 col1" >$153,779</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row7_col2" class="data row7 col2" >7.6174%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row8_col0" class="data row8 col0" >2018-09-30</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row8_col1" class="data row8 col1" >$168,443</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row8_col2" class="data row8 col2" >8.3438%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row9_col0" class="data row9 col0" >2018-10-31</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row9_col1" class="data row9 col1" >$171,495</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row9_col2" class="data row9 col2" >8.4950%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row10_col0" class="data row10 col0" >2018-11-30</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row10_col1" class="data row10 col1" >$119,961</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row10_col2" class="data row10 col2" >5.9423%</td>
        </tr>
        <tr>
                            <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row11_col0" class="data row11 col0" >2018-12-31</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row11_col1" class="data row11 col1" >$163,867</td>
                    <td id="T_c509ac4a_202d_11ea_9e55_cc2f7187c201row11_col2" class="data row11 col2" >8.1171%</td>
        </tr>
</tbody></table>
日期sum月占比
# 按月分析销售金额，并显示每月销售额占年度销售总额比例
by=[pd.Grouper(key='日期', freq='M')]#自定义字段的格式
monthly_sales=df.groupby(by)["金额"].agg(["sum"]).reset_index()
monthly_sales["月占比"]=monthly_sales["sum"]/df["金额"].sum()

# 3.使用渐变色格式字典控制每列的格式
format_dict = {'sum': '${0:,.0f}', '日期': '{:%Y-%m-%d}', '月占比': '{:.4%}'}
(
    monthly_sales
    .style
    .format(format_dict)
    .background_gradient(subset=["sum"],cmap="PRGn")
)

            <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row0" class="row_heading level0 row0" >0</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row0_col0" class="data row0 col0" >2018-01-31</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row0_col1" class="data row0 col1" >$185,362</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row0_col2" class="data row0 col2" >9.1818%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row1" class="row_heading level0 row1" >1</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row1_col0" class="data row1 col0" >2018-02-28</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row1_col1" class="data row1 col1" >$146,212</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row1_col2" class="data row1 col2" >7.2426%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row2" class="row_heading level0 row2" >2</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row2_col0" class="data row2 col0" >2018-03-31</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row2_col1" class="data row2 col1" >$203,921</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row2_col2" class="data row2 col2" >10.1012%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row3" class="row_heading level0 row3" >3</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row3_col0" class="data row3 col0" >2018-04-30</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row3_col1" class="data row3 col1" >$174,574</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row3_col2" class="data row3 col2" >8.6475%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row4" class="row_heading level0 row4" >4</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row4_col0" class="data row4 col0" >2018-05-31</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row4_col1" class="data row4 col1" >$165,419</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row4_col2" class="data row4 col2" >8.1940%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row5" class="row_heading level0 row5" >5</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row5_col0" class="data row5 col0" >2018-06-30</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row5_col1" class="data row5 col1" >$174,089</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row5_col2" class="data row5 col2" >8.6235%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row6" class="row_heading level0 row6" >6</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row6_col0" class="data row6 col0" >2018-07-31</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row6_col1" class="data row6 col1" >$191,662</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row6_col2" class="data row6 col2" >9.4939%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row7" class="row_heading level0 row7" >7</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row7_col0" class="data row7 col0" >2018-08-31</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row7_col1" class="data row7 col1" >$153,779</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row7_col2" class="data row7 col2" >7.6174%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row8" class="row_heading level0 row8" >8</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row8_col0" class="data row8 col0" >2018-09-30</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row8_col1" class="data row8 col1" >$168,443</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row8_col2" class="data row8 col2" >8.3438%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row9" class="row_heading level0 row9" >9</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row9_col0" class="data row9 col0" >2018-10-31</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row9_col1" class="data row9 col1" >$171,495</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row9_col2" class="data row9 col2" >8.4950%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row10" class="row_heading level0 row10" >10</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row10_col0" class="data row10 col0" >2018-11-30</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row10_col1" class="data row10 col1" >$119,961</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row10_col2" class="data row10 col2" >5.9423%</td>
        </tr>
        <tr>
                    <th id="T_7f24e028_202e_11ea_9045_cc2f7187c201level0_row11" class="row_heading level0 row11" >11</th>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row11_col0" class="data row11 col0" >2018-12-31</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row11_col1" class="data row11 col1" >$163,867</td>
                    <td id="T_7f24e028_202e_11ea_9045_cc2f7187c201row11_col2" class="data row11 col2" >8.1171%</td>
        </tr>
</tbody></table>
日期sum月占比
# 按月分析销售金额，并显示每月销售额占年度销售总额比例
by=[pd.Grouper(key='日期', freq='M')]#自定义字段的格式
monthly_sales=df.groupby(by)["金额"].agg(["sum"]).reset_index()
monthly_sales["月占比"]=monthly_sales["sum"]/df["金额"].sum()

# 4.使用单元格柱形格式字典控制每列的格式
format_dict = {'sum': '${0:,.0f}', '日期': '{:%Y-%m-%d}', '月占比': '{:.4%}'}
(
    monthly_sales
    .style
    .format(format_dict)
    .hide_index()
    .bar(color="#FFA07A",vmin=100_000,subset=["sum"],align="zero")
    .bar(color='lightblue', vmin=0, subset=['月占比'], align='zero')
    .set_caption("2018年销售一览表")
)

            <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row0_col0" class="data row0 col0" >2018-01-31</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row0_col1" class="data row0 col1" >$185,362</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row0_col2" class="data row0 col2" >9.1818%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row1_col0" class="data row1 col0" >2018-02-28</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row1_col1" class="data row1 col1" >$146,212</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row1_col2" class="data row1 col2" >7.2426%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row2_col0" class="data row2 col0" >2018-03-31</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row2_col1" class="data row2 col1" >$203,921</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row2_col2" class="data row2 col2" >10.1012%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row3_col0" class="data row3 col0" >2018-04-30</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row3_col1" class="data row3 col1" >$174,574</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row3_col2" class="data row3 col2" >8.6475%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row4_col0" class="data row4 col0" >2018-05-31</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row4_col1" class="data row4 col1" >$165,419</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row4_col2" class="data row4 col2" >8.1940%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row5_col0" class="data row5 col0" >2018-06-30</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row5_col1" class="data row5 col1" >$174,089</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row5_col2" class="data row5 col2" >8.6235%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row6_col0" class="data row6 col0" >2018-07-31</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row6_col1" class="data row6 col1" >$191,662</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row6_col2" class="data row6 col2" >9.4939%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row7_col0" class="data row7 col0" >2018-08-31</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row7_col1" class="data row7 col1" >$153,779</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row7_col2" class="data row7 col2" >7.6174%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row8_col0" class="data row8 col0" >2018-09-30</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row8_col1" class="data row8 col1" >$168,443</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row8_col2" class="data row8 col2" >8.3438%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row9_col0" class="data row9 col0" >2018-10-31</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row9_col1" class="data row9 col1" >$171,495</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row9_col2" class="data row9 col2" >8.4950%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row10_col0" class="data row10 col0" >2018-11-30</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row10_col1" class="data row10 col1" >$119,961</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row10_col2" class="data row10 col2" >5.9423%</td>
        </tr>
        <tr>
                            <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row11_col0" class="data row11 col0" >2018-12-31</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row11_col1" class="data row11 col1" >$163,867</td>
                    <td id="T_e2b931d8_202e_11ea_8fb6_cc2f7187c201row11_col2" class="data row11 col2" >8.1171%</td>
        </tr>
</tbody></table>
2018年销售一览表
日期sum月占比
def sparkline_str(x):
    bins=np.histogram(x)[0]#直方图
    s1="".join(sparklines(bins))
    return s1
sparkline_str.__name__ = "走势图"
df.groupby("姓名")["数量","金额"].agg(["mean",sparkline_str])
数量金额
mean走势图mean走势图
姓名
Barton LLC24.890244▄▄▃▂▃▆▄█▁▄1334.615854█▄▃▆▄▄▁▁▁▁
Cronin, Oberbrunner and Spencer24.970149█▄▁▄▄▇▅▁▄▄1339.321642█▅▅▃▃▃▂▂▁▁
Frami, Hills and Schmidt26.430556▄▄▁▂▇█▂▂▅▅1438.466528█▅▄▇▅▃▄▁▁▁
Fritsch, Russel and Anderson26.074074▁▄▇▃▂▂█▃▄▄1385.366790▇█▃▄▂▂▁▂▁▁
Halvorson, Crona and Champlin22.137931▇▆▆▇█▁▄▂▄▃1206.971724██▆▅▁▃▂▂▂▂
Herman LLC24.806452▄▃▅▁▆▄▂▆▃█1336.532258█▅▇▄▅▄▁▃▂▂
Jerde-Hilpert22.460674▄▄█▁▂▅▃▂▄▃1265.072247█▄▅▂▁▂▃▂▂▁
Kassulke, Ondricka and Metz25.734375▂▂▁▁▂▂▁▅▄█1350.797969█▆▆▄▄▃▂▁▁▂
Keeling LLC24.405405▁▄▇▃▅█▃▄▃▆1363.977027▅█▆▃▄▂▂▁▁▁
Kiehn-Spinka22.227848▃▂█▂▃▅▄▁▄▁1260.870506█▇▄▃▃▂▁▂▁▁
Koepp Ltd21.829268▅▇█▆▄▇▅▁▅▇1264.152927█▇▅▂▄▂▂▂▁▁
Kuhn-Gusikowski22.808219▂▄█▄▃▁█▄▂▄1247.866849▆█▄▃▃▃▃▁▁▁
Kulas Inc24.095745▇▃▇▂▇▁▅▆█▆1461.191064█▅█▂▄▄▄▂▁▁
Pollich LLC23.383562█▂▅▂▃▆▁▂▄▇1196.536712█▆▆▃▃▃▂▂▁▁
Purdy-Kunde27.358491▄▅█▁▄▇▅█▇█1469.777547█▅▄▃▄▃▃▂▁▂
Sanford and Sons24.000000▂▂▂▆▁█▂▂▁▅1391.872958▅▇█▃▃▄▁▃▁▂
Stokes LLC24.527778▄▄▄▁▃▂▄█▄▄1271.332222█▇▆▆▄▂▂▃▁▂
Trantow-Barrows24.159574▅▄▅▂▃▃▄▄▁█1312.567872█▇▅▆▃▂▂▁▁▁
White-Trantow26.255814▃▂▆▆▃██▁██1579.558023▄█▆▅▄▃▄▂▁▃
Will LLC24.702703▂█▁▄▄▄▂▅▅▄1411.318919▆█▄▅▄▂▁▂▁▂
迷心兔
关注
  • 0
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
探索性分析——某医院18年销售数据分析
weixin_41512727的博客
03-25 2103
针对某医院18年销售记录，做简单的数据分析，熟悉相关语法及分析过程。一、分析目的以某医院18年销售数据为例，了解18年的销售情况，分析几个业务指标，例如：月均消费次数，月均消费金额、客单价以及消费趋势等，可以用于了解不同季节的病情、指导医院备货等。二、 数据分析过程数据分析过程基本包括：数据获取、数据清洗、模型构建、数据可视化、相关分析等1、数据获取根据已有的18年销售单据，提取相应的数据。（本次...
pandas数据分析
changan
08-03 844
将指定多个聚合函数，分组统计，指定数组
Python分析电商销售数据
记录分享编程与冲浪知识
10-30 1684
DataFrame，python日期转换，日期筛选
用pandas和numpy分析药店的营业数据
GitHub：https://github.com/myp020301
10-20 2159
用pandas和numpy分析药店的营业数据 以下是某连锁药店销售数据，请使用numpy、pandas相关做分析。要求如下：‪‬‪‬‪‬‪‬‪‬‮‬‫‬‮‬‪‬‪‬‪‬‪‬‪‬‮‬‫‬‮‬‪‬‪‬‪‬‪‬‪‬‮‬‪‬‭‬‪‬‪‬‪‬‪‬‪‬‮‬‫‬‫‬‪‬‪‬‪‬‪‬‪‬‮‬‪‬‫‬‪‬‪‬‪‬‪‬‪‬‮‬‪‬‮‬ 序号 药名 销量 价格 分店 1 双黄连口服液 89 20 四季青分店 2 莲花清瘟胶囊 45 21 四季青分店 3 藿香正气水 55 10 四季青分店 4 大山楂丸
使用Pandas对销售数据进行分析
cy364328541的博客
03-30 4076
现在我们获得了一个连续数据的数据集data.txt，该数据集由年，月份，和AB两地某商品的销售数据组成，我们希望发现这两地销售数据之间是否有关联。
Pandas超市商品交易数据分析
lkyangg
10-11 1557
首先导入pandas，读取Excel文件中的数据为data： import pandas as pd data = pd.read_excel(r'E:\Jupyter\Study\超市.xls') 查看前五行数据： data.head() 查看各列的数据类型，是否为空值： 去除列名中的空格和斜杠，以便后面引用时不会报错： data = data.rename(columns = lambda x:x.replace(" ","").replace("/","")) 检查去除后的列名： data.
Python进阶-Pandas数据分析库
06-11
Pandas是python中非常常用的数据分析库，在数据分析，机器学习，深度学习等领域经常被使用。本课程会讲解到pandas中最核心的一些知识点，包括Series以及DataFrame的构建，赋值，操作，选择数据，合并等等，以及使用...
数据分析-pandas入门-案例分析
最新发布
09-08
在数据分析领域，Pandas是一个非常重要的工具，尤其对于初学者来说，它是理解并处理数据集的首选库。本文将深入探讨在"数据分析-pandas入门-案例分析"中的关键知识点，帮助你更好地掌握Pandas的使用。 首先，让我们...
数据科学-Pandas数据分析讲义.pdf
11-30
数据科学-Pandas数据分析讲义.pdf 数据科学是一门与数据处理和分析相关的学科，旨在从大量数据中提取有价值的信息，指导企业决策。数据科学的概念产生于20世纪60年代~80年代之间，逐渐演变为独立学科，横跨计算机...
数据分析-pandas入门-数据聚合与分组
09-08
系列文章“Python数据分析之Pandas入门（中）”的第七小节，主要介绍了在载入、合并和准备数据集后，可能还需要对源数据集进行过滤、变换和分割等操作。，本节内容与 中的“六、数据规整”一同作为将用于报告的数据...
Python数据分析库--Pandas视频教程
07-29
Python数据分析库--Pandas视频教程，pandas 是基于NumPy 的一种工具，该工具是为了解决数据分析任务而创建的。Pandas 纳入了大量库和一些标准的数据模型，提供了高效地操作大型数据集所需的工具。pandas提供了大量能...
PythonPandas_SalesAnalysis:使用Python Pandas进行销售分析
03-14
PythonPandas_SalesAnalysis 使用Python Pandas进行销售分析
Pandas 按周、月、年、统计数据
小旺的博客
12-12 1万+
Pandas 按周、月、年、统计数据 第一步 将日期转为时间格式 并设置为索引 import pandas as pd data=pd.read_excel('5\TB201812.xls',usecols=['订单创建时间','总金额']) print(data) data['订单创建时间']=pd.to_datetime(data['订单创建时间']) data=data.set_index('订单创建时间') print(data) 按周、月、季度、年统计数据 import pandas as p
Pandas应用案例
m0_54139855的博客
09-23 844
文章目录1．统计月度销售额2．统计品牌销售占比3.统计各地区的月度销售额4．统计各渠道的品牌销量5.统计不同售价区间的月度销量占比按照分数段分箱 import numpy as np import pandas as pd import matplotlib.pyplot as plt plt.rcParams['font.sans-serif'] = ['SimHei'] plt.rcParams['axes.unicode_minus'] = False %config InlineBackend.
第四章 pandas统计分析基础
qq_44913558的博客
05-05 6231
第四章 pandas统计分析基础 4.1读/写不同数据源的数据 4.1.1读/写数据库数据 1、数据库数据读取 import MySQLdb from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker engine = create_engine("mysql+pymysql://root:123456@127.0.0.1/testdb?charset=utf8mb4") session = sessionma
pandas统计每月记录数_pandas如何计算汇总统计数据?
weixin_30096321的博客
01-23 4638
In [1]: import pandas as pd本教程使用的数据:泰坦尼克号的数据本教程使用泰坦尼克号数据集，以 CSV 格式存储，数据由以下数据列组成: * 乘客身份证(PassengerId): 每位乘客的身份证。 * 幸存者(Survived): 这个特性的值为0和1.0，表示没有幸存，1表示幸存。 * 等级(Pclass): 有三个等级: 一等，二等和三等。 ...
pandas汇总和描述性统计
热门推荐
qiao8756的博客
06-28 1万+
import pandas as pd import numpy as np In [3]:df = pd.DataFrame([[1.4, np.nan], [7.1, -4.5], [np.nan, np.nan], [0.75, -1.3]], index=['a', 'b', 'c', 'd'], ...
pandas统计分析（上）
m17635262186的博客
04-16 1949
本文主要介绍如何导入外部数据、数据抽取、以及数据的增加、修改、删除，还包括数据清洗、索引设置、数据排序与排名等，为后续数据处理和数据分析打下良好的基础。
python数据分析-pandas玩转excel
07-20
在使用Pandas进行Excel数据分析时，我们首先需要使用`pandas.read_excel()`函数读取Excel文件，并将其存储为一个Pandas的DataFrame对象。这样可以轻松地使用Pandas的各种数据处理和分析功能。 Pandas提供了一系列的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值