数据分析资料

Pandas

https://www.jianshu.com/p/7ac36fafebea

 

series: 一维

dataframe： 二维

Excel

https://jingyan.baidu.com/article/b7001fe19422f50e7282dd0c.html

DataFrame.set_index()

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.set_index.html

pandas DataFrame 根据多列的值做判断，生成新的列值

https://blog.youkuaiyun.com/qq_30565883/article/details/79464266

 

从excel或者csv文件中读取文件，不需要加index_col=0才可以按列读取

转存失败重新上传取消

 

DataFrame.drop

.drop() 返回的是一个新对象，元对象不会被改变

删除行 df.drop([0,1,2…]) or df.drop(index=[0,1,2…]) drop后会生成一个新的dataframe

删除列 df.drop(columns=[a,b,…])  or df.drop([a,b…],axis=1)因为默认是0，所以删除列时一定要加上axis=1

Numpy

https://time.geekbang.org/column/article/73756

避免隐式拷贝，避免采用隐式拷贝，而是采用就地操作的方式。

 

set()  list[]  字典和集合的性能高

正则表达式学习

https://regexone.com/lesson/character_ranges

tool： https://regex101.com/

 

如何用Python和正则表达式抽取文本结构化信息？

https://mp.weixin.qq.com/s?__biz=MzIyODI1MzYyNA==&mid=2653540664&idx=1&sn=fbd0088427d8133b80964e010df2494d&chksm=f389bbefc4fe32f9a2b1255779e67cbfb49259a6d43e1261d94abcc0ae4ea8adef87719038cd&mpshare=1&scene=1&srcid=&sharer_sharetime=1569459198306&sharer_shareid=66c747902fb16367a744d5b42b84dc7e&key=db5072f939534d61e42c9ba002d8ad60a1d90e1c5cfa12f651cf7d2bd090a42206eaddf3502f0d72ad1618858b210dda04d8a8e8a472bec70883c963fafd2aee65cc3817a41fc261e92ee3dcd120c567&ascene=1&uin=MTkxNDIwOTg2Mw%3D%3D&devicetype=Windows+10&version=62060833&lang=zh_CN&pass_ticket=NFt8J3VPCB2NU4ijzBuwZY9kk06VylFcO3xp5Mtw2bLDw8gakOKjPTr6v169zjM6

 

抽取几个房间

href="https:..www.panpacificseattle.com.accommodations\/([a-z]*-)*([a-z]*)\/

 

 

time

命名文件名包含当前时间

https://blog.youkuaiyun.com/hdandan2015/article/details/78719915

 

 

DataFrame to list

https://datatofish.com/convert-pandas-dataframe-to-list/

 

 

Convert list to DataFrame

https://datatofish.com/list-to-dataframe/