![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
pandas数据分析
qq_42679379
这个作者很懒,什么都没留下…
展开
-
pandas-matplotlib柱状图
# -*-coding:utf-8 -*-import pandas as pdimport matplotlib.pyplot as pltstudents = pd.read_excel('C:/Users/asus/Downloads/pandas/009/Students.xlsx')students.sort_values(by='Number', inplace=True,a...转载 2018-12-12 17:19:56 · 434 阅读 · 0 评论 -
pandas-读取csv,tsv,txt,文件
import pandas as pd#读取CSV文件# student1 = pd.read_csv('C:/Users/zuxia/Downloads/022/Students.csv',index_col='ID')#pandas读取tsv和txt文件都用read_csv()方法读取,然后设置set参数的形式student2 = pd.read_csv('C:/Users/zuxia...转载 2018-12-13 19:59:32 · 3472 阅读 · 0 评论 -
cdm输入命令: pyspider all 报错如下:请解答
原创 2018-12-14 22:49:22 · 4079 阅读 · 13 评论 -
创建文件
DataFrame对象一个快速高效的DataFrame对象,用于集成索引的数据操作;用于在内存数据结构和不同格式之间读取和写入数据的工具:CSV和文本文件,Microsoft Excel,SQL数据库和快速HDF5格式;智能数据对齐和缺失数据的集成处理:在计算中获得基于标签的自动对齐,并轻松地将凌乱的数据处理成有序的形式;灵活的数据集整形和旋转;基于智能标签的切片,花式索引和 大数据集...转载 2018-12-11 15:19:15 · 235 阅读 · 0 评论 -
pandas读取文件
import pandas as pdpeople = pd.read_excel("C:/Users/asus/Downloads/People - 副本.xlsx")# print(people.shape)# print(people.columns)# print(people.head(3))# print(people.tail(3))#设置列名# people.cl...转载 2018-12-11 15:23:58 · 145 阅读 · 0 评论 -
pandas设置列,行,单元格
import pandas as pd#序列# s1 = pd.Series()# s1.name()# d = {"x":100,"y":200,"z":300}# s1 = pd.Series(d)# print(s1.)# L1 = [100,200,300]# L2 = ["X","Y","Z"]# s1 = pd.Series(L1,index=L2)# pr转载 2018-12-11 15:25:10 · 4101 阅读 · 0 评论 -
pandas数字读取和填充
import pandas as pdfrom datetime import date,timedeltabooks = pd.read_excel("C:/Users/asus/Downloads/Books.xlsx", skiprows=3, usecols="C:F",index_col=None, dtype={"ID":str,"InStore"转载 2018-12-11 15:26:15 · 339 阅读 · 0 评论 -
pandas填充日期序列
import pandas as pdfrom datetime import date,timedeltabooks = pd.read_excel("C:/Users/asus/Downloads/Books.xlsx", skiprows=3, usecols="C:F",index_col=None, dtype={"ID":str,"InStore":str,"Date":str}...转载 2018-12-11 15:27:28 · 1904 阅读 · 1 评论 -
pandas函数填充
import pandas as pd#读取文件books = pd.read_excel("C:/Users/asus\Downloads/Books (1).xlsx",index_col="ID")#获取列# books["Price"] = books["ListPrice"] *books["Discount"]#列二# for i in books.index:# ...转载 2018-12-11 15:29:30 · 307 阅读 · 0 评论 -
pandas排序多重排序
import pandas as pdproducts = pd.read_excel("C:/Users/asus/Downloads/Code for 007/List.xlsx",index_col="ID")# products.sort_values(by="Price",inplace=True,ascending=False)products.sort_values(by=[...转载 2018-12-11 15:30:57 · 1348 阅读 · 0 评论 -
pandas数据过滤和筛选
import pandas as pddef age_18_to_30(a): return 18<=a<30def level_a(s): return 85 <= s <= 100students = pd.read_excel("C:/Users/asus/Downloads/008/Students.xlsx",index_col="I...转载 2018-12-11 15:32:06 · 407 阅读 · 0 评论 -
pandas-旋转数据表
import pandas as pdpd.options.display.max_columns=999videos = pd.read_excel('C:/Users/zuxia/Downloads/021/Videos.xlsx',index_col='Month')#旋转数据表table = videos.transpose()print(table)转载 2018-12-13 19:58:21 · 618 阅读 · 0 评论 -
pandas-定位消除重复数据
import pandas as pdstudent = pd.read_excel('C:/Users/zuxia/Downloads/020/Students_Duplicates.xlsx')#去掉数据中的重复数据# student.drop_duplicates(subset='Name',inplace=True,keep='last')# print(student)#找出重...转载 2018-12-13 19:57:24 · 233 阅读 · 0 评论 -
pandas-matplotlib绘制分组柱图
# -*-coding:utf-8 -*-import pandas as pdimport matplotlib.pyplot as pltstudents = pd.read_excel('C:/Users/asus/Downloads/pandas/010/Students.xlsx')students.sort_values(by='2017',inplace=True,ascen...转载 2018-12-12 17:38:35 · 4197 阅读 · 0 评论 -
pandas-matplotlib叠加柱状图,水平柱状图
# -*-coding:utf-8 -*-import pandas as pdimport matplotlib.pyplot as pltusers = pd.read_excel('C:/Users/asus/Downloads/pandas/011/Users.xlsx')users['Total'] = users['Oct']+users['Nov']+users['Dec'...转载 2018-12-12 17:40:40 · 4542 阅读 · 0 评论 -
pandas-matplotlib饼图
# -*-coding:utf-8 -*-import pandas as pdimport matplotlib.pyplot as pltstudents = pd.read_excel("C:/Users/asus/Downloads/pandas/012/Students.xlsx",index_col='From')print(students)students['2017...转载 2018-12-12 17:42:25 · 926 阅读 · 0 评论 -
pandas-matplotlib绘制折线趋势图,叠加区域图
# -*-coding:utf-8 -*-import pandas as pdimport matplotlib.pyplot as pltweeks = pd.read_excel('C:/Users/asus/Downloads/pandas/013/Orders.xlsx',index_col='Week')print(weeks)print(weeks.columns)w...转载 2018-12-12 17:44:47 · 3339 阅读 · 0 评论 -
pandas-matplotlib散点图,直方图,密度图
# -*- coding:utf-8 -*-import pandas as pdimport matplotlib.pyplot as pltpd.options.display.max_columns=777homes = pd.read_excel("C:/Users/asus/Downloads/pandas/014/home_data.xlsx")print(homes.hea...转载 2018-12-12 17:46:23 · 1260 阅读 · 0 评论 -
pandas-matplotlib密度图-数据相关性
# -*-coding:utf-8 -*-import pandas as pdimport matplotlib.pyplot as pltpd.options.display.max_columns=777homes = pd.read_excel("C:/Users/asus/Downloads/pandas/014/home_data.xlsx")# print(homes.h...转载 2018-12-12 17:48:14 · 877 阅读 · 0 评论 -
pandas-matplotlib联合多表
# -*-coding:utf-8 -*-import pandas as pdimport matplotlib.pyplot as pltstudents = pd.read_excel("C:/Users/asus/Downloads/pandas/016/Student_Score.xlsx",sheet_name='Students',index_col='ID')scores...转载 2018-12-12 17:50:09 · 156 阅读 · 0 评论 -
pandas数据验证
import pandas as pdimport matplotlib.pyplot as pltstudents = pd.read_excel("C:/Users/asus/Downloads/pandas/016/Student_Score.xlsx",sheet_name='Students',index_col='ID')scores = pd.read_excel("C:/U...转载 2018-12-13 19:51:25 · 778 阅读 · 0 评论 -
pandas一列数据分成二列
import pandas as pdimport matplotlib.pyplot as pltstudents = pd.read_excel("C:/Users/asus/Downloads/pandas/016/Student_Score.xlsx",sheet_name='Students',index_col='ID')scores = pd.read_excel("C:/U...转载 2018-12-13 19:52:17 · 1042 阅读 · 0 评论 -
pandas-求和-求平均-统计导引
import pandas as pdstudent = pd.read_excel("C:/Users/zuxia/Downloads/019/Students.xlsx",index_col='ID')temp = student[['Test_1', 'Test_2', 'Test_3']]row_sum = temp.sum(axis=1)row_sum = temp.mean(...转载 2018-12-13 19:53:35 · 954 阅读 · 0 评论 -
win10 keplerzl安装报错
报错如下 ERROR: Complete output from command python setup.py egg_info: ERROR: Traceback (most recent call last): File "<string>", line 1, in <module> File "C:\Users\asus\AppD...原创 2019-07-17 00:03:41 · 419 阅读 · 0 评论