小白踩坑记第二章：Python第二期

港控/mmm° 2023-02-16 06:39 1阅读 0赞

![format_png][]

![format_png 1][]

![format_png 2][]

b\[0:2,:3\]=100 \#这个应该是将第0行和第1行&第3列都改成100吗，出来的结果第三列并没有变化」

这个可以叫切片，指定索引修改数组中的数值。3:是从3开始往后，:3是从0开始到3，3不取。另外，.r直接切片，拼接可以用.stack

![format_png 3][]

![format_png 4][]

![format_png 5][]

![format_png 2][]

第一个问题，打开文件不用open（）

读取文件的方式有很多种，open是一种，这里是一种

![format_png 3][]

![format_png 4][]

![format_png 6][]

![format_png 2][]

第二问题，np.loadtxt方法是啥意思

就是读取txt文件中的信息

![format_png 3][]

![format_png 4][]

![format_png 7][]

![format_png 2][]

第三个问题，n\_samples,n\_features = x.shape这个shape 啥意思

shape相当于一个方法，这涉及到基础语法。代码中给了shape的注释。

![format_png 3][]

![format_png 4][]

![format_png 6][]

![format_png 2][]

第三个问题，n\_samples,n\_features = x.shape这个shape 啥意思

shape相当于一个方法，这涉及到基础语法。代码中给了shape的注释，shape就是数组的形状，几行几列。

![format_png 3][]

![format_png 8][]

![format_png 9][]

![format_png 2][]

if sample\[2\] ==1:

num\_bread\_purchases+=1

这个if 中，上一个不是说sample是在x中for循环，那就是元素，怎么还有sample\[\]

sample\[i\]表示第几个特征，共五个特征。

![format_png 3][]

![format_png 4][]

![format_png 6][]

![format_png 2][]

这个去重，前面为啥为啥是u，in![format_png 10][]

就是给u和indice两个变量同时赋值，避免写两次。unique返回值由两个值组成，用两个变量承接。

![format_png 3][]

![format_png 8][]

![format_png 5][]

![format_png 2][]

display和print 区别？网上没有搜到。下面这个，输出不了

import pandas as pd

from pandas import Series,DataFrame

import numpy as np

\#合并

df1=pd.DataFrame(np.arange(6).reshape(3,2),columns=\['four','five'\])

df2= pd.DataFrame(np.arange(6).reshape(2,3),columns=\['one','two','three'\])

display(df1,df2)

NameError: name 'display' is not defined

在jupyter notebook才能，显示出来是一个表格。print(display(df1,df2))试一下，如果显示缺什么库下载就好。

![format_png 3][]

![format_png 8][]

![format_png 11][]

![format_png 2][]

在字典里的时候明明是省份在前，为啥输出的时候就是pop在前面。

![format_png 12][]

我们输出是对的的，应该是你环境的问题，或者之间输出导致的缓存，清理一下。

![format_png 3][]

![format_png 4][]

![format_png 13][]

![format_png 14][]

import  xlrd

data = xlrd.open\_workbook(r'C:/Users/WT/Deskto/1.xlsx')

table=xlsx.sheet\_by\_index(0)

\#索引index（n）中的参数代表第n个表

print(table.cell\_value(0,0))

print(table.cell\_value(0,1))

print(table.cell\_value(1,3))

print("----------------------")

print(table.cell(1,3).value)

print(table.row(1)\[3\].value)

print("======================")

print(table.cols(1)\[3\].value)

桌面拼写错误，第二次没加后缀

![format_png 15][]

![format_png 16][]

![format_png 17][]

![format_png 14][]

为什么会变成＃号了

![format_png 18][]

改一下单元格格式,单元格宽度，拉一下

![format_png 15][]

![format_png 16][]

![format_png 19][]

![format_png 14][]

我思路局限了，我做的字典，然后for循环查询出来写进去的，应该没有比这更蠢的办法了

![format_png 20][]

pandas 没有可以对比列的方法么？然后读取进来 就是一个 DataFrame,然后取 sn 与另一个 相比较 pandas 也可以排除重复值。取日期那一列 取最近的,那个读取多个txt 文件的 就是一个案例。

![format_png 15][]

![format_png 16][]

![format_png 17][]

![format_png 14][]

想问下这个的话，是怎么个改法：writer = pd.ExcelWriter('C:\\\\Users\\\\JackFeng\\\\Desktop/1/\{table\_name\}\_666.xlsx'.format(table\_name=table\_name))

我直接改成了自己xls文件的路径 writer = pd.ExcelWriter('/Users/kath/Desktop/py-excel/1.xls')

我是将dataframe写入excel，但是没写入任何东西

你没有读取哪来写，dataframe 有to excel的方法

![format_png 15][]

![format_png 16][]

![format_png 13][]

![format_png 14][]

小姐姐有空的话可以分享一下你的解题思路呀，有重复的怎么处理呀

![format_png 21][]

![format_png 14][]

我的思路就是：先读取表格到dataframe，再用merge函数并表，然后把新表写入excel。

![format_png 13][]

![format_png 14][]

看了那个代码，发现是改名SN为盒子SN然后合并，而困扰我的主要矛盾：排除重复项挑出日期最近的、进一步优化标注处理多余项等，解决方案好像不在里面唉，比如说我把4~6行数据改重复，怎么挑出5除去4和6

![format_png 22][]

groupby 然后再取日期得。拿sql 更加简单了，造个数据试试就知道了，https://www.jianshu.com/p/ae94c28f2ad8 参考一下这个，均值换成 日期。

![format_png 15][]

![format_png 16][]

那么 还有一个问题思考一下：日期不是最大就一定就是对的，比如 6.1和 5.31是否需要转换成时间戳再做比较，怎么能确保就是最近的那个

![format_png 15][]

![format_png 16][]

![format_png 21][]

![format_png 14][]

groupby就可以做到去重&筛出日期最大的那个了，标黄是我加的重复项。

groupby之后只留下了一条

![format_png 23][]

![format_png 13][]

![format_png 14][]

groupby之后只留下了一条？我好像不行，你改成4/22试下可以吗

![format_png 13][]

![format_png 14][]

出来的改成4/22的话，跑出来就是第二条4/25咯，发现出现问题是排序后同一行数据有变化了，因为你同一行的其它数据都一样

![format_png 19][]

![format_png 14][]

我觉得这个多行不一样的，groupby不能解决（类似像excel的数据透视表也不能酱紫玩的），所以要么是先单独将日期列groupby，再写回原表，再做merge？如果是这样，那不如先排序再去重简单点

![format_png 13][]

![format_png 14][]

它是按每列排序然后去重，并没有考虑行

![format_png 24][]

![format_png 14][]

有大神懂python自动化测试unittest用例封装吗？我想请教个问题

![format_png 25][]

![format_png 26][]

![format_png 14][]

试试测试套件，一般多个用例不是都放在套件里执行的吗。或者在第一个用例加一个关闭连接的操作。期望值和预期值不相等

![format_png 27][]

[小白踩坑记第一章：Python第一期][Python]

喜欢就点个在看吧~

![format_png 28][]

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2dpZi9xaWFTbDNSVDFSYzM1cUlweTlNeklQWThCN2Y3OEFDTERNVTl5Q1NUR1VvS3RCMHFpY2liZlVVVjVLUkg4ZmliRmljRTBnWnRhc1lHeExBSmUyYTI0c1lMVU9RLzY0MA?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuQ1JsY2dBRGNJVEhNU25XVDZiU05TanNZelluT1MzQzg3bWhVYVlvT2Nmbks0UDBTQUl6MHRBLzY0MA?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuaEtxSUlpYXVTbW56Vk5oYms3aWJuczNSMEhMTjJjZDl0SmhZOEJVaWFNY3hjMmlhaEZCTjVhcXoxdy82NDA?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuMWNLY2I0cWx1MmljU1RIa2RJUHdsdGgyV1pKeGlhWEpCSXpWZmlhRGtBWDVjZ0d2RXprWlZVbXJRLzY0MA?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuNmliVkkzckN1ckx6TUppYzh6RnFlakRCRHlMYmljOXFiUUVCc1R2cU1kcHdIbGZhMVU3YVI3Y1JnLzY0MA?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuMXg0b0h0elBrNERMOGFRb1U5SHJ2TllMSUZ4QlZ3TE5jaHdXRHBOVHd4M2tXMWtTOGliYktYUS82NDA?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuMmNKYUdCWDZIYlhLalNydFFqUTlhMFRoTFY1ajZYVjFsckc1ZzMxTGc4MHZQa0hqTDBwazl3LzY0MA?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuWmljQUVqS1ZQWEl2eUUyNUlnR3ZnSnN1Y0JtaWJnUDlIQnVlWUlweVNGajdUaWI4SWliNGpkeU52Zy82NDA?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuaWFNY3k1Z2c2cVFhSENUekJDTU4yTjlkWXRpY1dMc3dPb2liZkpUbm9ORWVabEhQa3JVeTZ1R0FnLzY0MA?x-oss-process=image/format,png
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuZTVDTEdVeG5ycEpoSmliaktuNUFKOWljU2RtTklhZktONERrcW5SRUU5THphT2JEUkJjMkxuelEvNjQw?x-oss-process=image/format,png
[format_png 10]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuN2pGSVRYbmxLdU81UUNIejJEbEd0QnFCUkJreFV0NXVLanFUR0VlVWd6VWprc3hQSFNDWmliZy82NDA?x-oss-process=image/format,png
[format_png 11]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFudjJYbUdseGZrVUdPOFplQkZiV2FGTUhQNFV2T3J4V2Uxc01wVk96czE4bTdsRFRjRFVLVzRnLzY0MA?x-oss-process=image/format,png
[format_png 12]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzFMNkJlUGV2NWxGa1kzYldpYzRIeVFuaWNKTHhyQXVvSTk0M1N6R3BZQ3lpY2d5aFRGeDVTdnVmWmljcUJBNjlWZVhsOFlHMDlzNUpqSVJRLzY0MA?x-oss-process=image/format,png
[format_png 13]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOQWhWV1V4R1gyaWNGRUdSM0hJUUJRSHBRMmhjMGd5ekZnS3lNRTdQc3hpYWliTFZBYkxGNmZUd1R3LzY0MA?x-oss-process=image/format,png
[format_png 14]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJObkZOZmo1RVhkaWNZSmEzb2ppYnFQbFNnd0o3ajBSekwxSXNhREVaSG5uMlptcDcyU1YyNUhwQ2cvNjQw?x-oss-process=image/format,png
[format_png 15]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOQ1JlTUdEQk5LZWljME41Y1R4aWFqRTJ5MU11dmJFS0JDVnFWQzFyZ1RHTGd4andmako4bHYxdlEvNjQw?x-oss-process=image/format,png
[format_png 16]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOeVdkU1BmNUhRWlpjM1g0R1oxVTdMNWRCaDJvdnMyaWN2QjVTY0RBUmwxanZHbGhPdjhZY2VIZy82NDA?x-oss-process=image/format,png
[format_png 17]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOdGtzNkFZb0VmVWR4eVpldnhIdnBLV3ZNWklzcHR4b3hpYkRSZnduNHluSHdMSWFEUDlEd0Fvdy82NDA?x-oss-process=image/format,png
[format_png 18]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOOFBBSG5FVTFKeGpQcDFZaGtpY2RzQVZvUXhiUFZVemREZzFQM000bFRYR3RhTHlWRE13NWdwQS82NDA?x-oss-process=image/format,png
[format_png 19]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOQjdsMmVXNm5kZW1mWmliRzlhZFBXdkNEbXN5TWpYV0lpYVc1T1BTS0kxYmhQa3VwTnA0M1kyalEvNjQw?x-oss-process=image/format,png
[format_png 20]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOWVhWQ2FTaWFwTXZpYTVYSXFxOU9Ka2Z3eEtDdHI0aWN4bkR0V3JIdlVobGNUaWNIWUE0OGlhS3BUV1EvNjQw?x-oss-process=image/format,png
[format_png 21]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOQk1TOXpZREZoeEtGbW5WS2ljdFlzR1pGeDZaZTgwSG1jTng4U1RIbHJtS1NBOWdLdEl5dWtBQS82NDA?x-oss-process=image/format,png
[format_png 22]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOSVIzTk1GODJ3Umc3b0FrSEtJN1o2YmVidm0xNnVwM2VUSzlqRWliN001U3llQmpLOU9oaHR4Zy82NDA?x-oss-process=image/format,png
[format_png 23]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOV0pGMlpyQTZha0NEclR2NTJhT0dPNUw4WFR1STBnc1JPaWE4aEJydVZGSWI5aWFrNEV0WG5XZ1EvNjQw?x-oss-process=image/format,png
[format_png 24]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOUmhReWFQdm1ycXhFSkxJNTNXTHhUdHlsODhmdW1PbkFVTjF6V0tIRXJpYm51Y3JvZHBEV1NNQS82NDA?x-oss-process=image/format,png
[format_png 25]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOODVuSE1Fcm9RN0JGUTBVbDVoM28zd1J6a2E3QjRzWHlKdzVrRTVKWlREdmhVaEg3VU9TbmliQS82NDA?x-oss-process=image/format,png
[format_png 26]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOSERkZVkyaWI0WUlEODNBRHdUdE1xVElWM0l1WEpUNlVOY0dBRE80THM0cEFEVGRpYllET0xDYXcvNjQw?x-oss-process=image/format,png
[format_png 27]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9xaWFTbDNSVDFSYzN1WjRCc2J6aWFFZ05UOTk2cG5WOXJOSFpTcUdFN2xPeFVSSm1FaWNQVzhyRXR1dkFXdVlDUmZHZHBPUFdrbHl2b0hjY1E1Y2NPaWNsdUEvNjQw?x-oss-process=image/format,png
[Python]: https://blog.csdn.net/weixin_40247412/article/details/106233628
[format_png 28]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2dpZi9iOTZDaWJDdDcwaWFhQkFpY0ROQ1NzNkgwTzBTQkdTQUxmbkhWcnlaV1VOWEFUN0x1YWlhN0U5MG5CdzhoaFhpYzFCQ2hpYnJXZFlNQ0w3UnhoUE1YMHBhZmljaFEvNjQw?x-oss-process=image/format,png