Pandas学习
文章平均质量分 61
小帅吖
无
展开
-
Pandas学习笔记(6)Renaming and Combining
Pandas学习笔记(6)Renaming and Combining1.理论部分1.重命名函数renamereviews.rename(columns={'points': 'score'})reviews.rename(index={0: 'firstEntry', 1: 'secondEntry'})reviews.rename_axis("wines", axis='rows').rename_axis("fields", axis='columns')2.合并函数有conc原创 2021-12-16 18:34:13 · 996 阅读 · 0 评论 -
Pandas学习笔记(5) Data Types and Missing Values
1.理论部分1.用dtype函数查看数据类型reviews.price.dtypedtype('float64')reviews.dtypescountry objectdescription object ... variety objectwinery objectLength: 13, dtype: object2.用astype函数更换数据类型reviews.points.astype(原创 2021-12-16 17:50:46 · 694 阅读 · 0 评论 -
Pandas学习笔记(4) Grouping and Sorting
Pandas学习笔记(4) Grouping and Sorting1.Who are the most common wine reviewers in the dataset? Create a Series whose index is the taster_twitter_handle category from the dataset, and whose values count how many reviews each person wrote.按照taster_twitter_ha原创 2021-12-16 17:40:34 · 1083 阅读 · 0 评论 -
Pandas学习笔记(3)Summary Functions and Maps
1.理论部分1.1 summary functionreviewsdescribe函数reviews.points.describe()count 129971.000000mean 88.447138 ... 75% 91.000000max 100.000000Name: points, Length: 8, dtype: float64reviews.taster_name.de原创 2021-12-15 23:43:48 · 2516 阅读 · 0 评论 -
Pandas学习笔记(2)Indexing, Selecting & Assigning
Pandas中两种常用索引函数loc和iloc,与python不同的是这两个 row-first, column-second。iloc是Index-based selection,loc是Label-based selection注:iloc使用Python stdlib索引模式,其中包含范围的第一个元素,排除最后一个元素。所以0:10将选择条目0…9。但是,loc中0:10将选择条目0…10。1.将表中的description列从review放到desc中desc = reviews.iloc[原创 2021-12-15 19:14:50 · 1226 阅读 · 0 评论 -
Pandas学习笔记(1)Creating, Reading and Writing
有两种核心对象一个是DataFrame,一个是Series1.创建一个如下的叫做fruits的DataFrame:import pandas as pdfruits = pd.DataFrame({'Apples':[30],'Bananas':[21]})2.创建一个如下的叫做fruit_sales的DataFrame:fruit_sales = pd.DataFrame({'Apples':[35,41],'Bananas':[21,34]},index = ['2017 Sales'原创 2021-12-15 17:17:23 · 2250 阅读 · 0 评论