
数据分析
伟伟哦
我只是一名小学生 能力一般 水平有限 一直抱着学习的态度
展开
-
python 字典 21里面有多少个
#_*_coding:utf-8_*_#字典 data = {}with open('/export/www/admin-analysis.geenmay.cn/home.log', 'r') as f: for line in f.readlines(): ls = line.strip().split("|"...原创 2019-12-26 16:24:12 · 148 阅读 · 0 评论 -
python pandas 查看数据集列和行
#查看数据集中的列import pandas#列用什么分割 --sepdf = pandas.read_csv('./gapminder.tsv',sep='\t')#获取列country_df = df['country']print(country_df)#显示前5行print(country_df.head())#现在是最后五行print(country_df.ta...原创 2019-09-21 22:49:39 · 10926 阅读 · 0 评论 -
python 读取csv pickle excel
import pandas as pdimport warningswarnings.filterwarnings("ignore")scientists = pd.read_csv('./data/scientists.csv')names = scientists['Name']print(names)import osif not os.path.exists('./ou...原创 2019-09-29 21:58:34 · 614 阅读 · 0 评论 -
python 行连接 合并
#连接与合并数据集: 行连接import pandas as pddf1 = pd.read_csv('./data/concat_1.csv')df2 = pd.read_csv('./data/concat_2.csv')df3 = pd.read_csv('./data/concat_3.csv')print(df1)print(df2)print(df3)row_c...原创 2019-09-30 00:00:24 · 732 阅读 · 0 评论 -
Python 列连接
(venv) E:\py3>python py19.py A B C D A B C D A B C D0 a0 b0 c0 d0 a4 b4 c4 d4 a8 b8 c8 d81 a1 b1 c1 d1 a5 b5 c5 d5 a9 b9 c9 d92 a2 ...原创 2019-09-30 11:47:39 · 355 阅读 · 0 评论 -
Python 行连接的内连接inner
import pandas as pddf1 = pd.read_csv('./data/concat_1.csv')df2 = pd.read_csv('./data/concat_2.csv')df3 = pd.read_csv('./data/concat_3.csv')df1.columns = ['A','B','C','D']df2.columns = ['E','F','...原创 2019-12-21 12:28:34 · 4786 阅读 · 0 评论 -
python 合并多个数据集
#合并多个数据集#合并: 关系型数据库中的两个表之间的连接#table1.field1 table2.field2 select table1.field1,table2.field2 from table1,table2 where table1.field1 = table2.field2#1. 一对一#2. 多对一#3. 多对多import pandas as pdpe...原创 2019-12-21 12:28:53 · 2347 阅读 · 0 评论 -
python 非值数据
#非值数据 Pandas中有哪些非值数据import pandas as pdfrom numpy import NaN,NAN,nan#NaN 是被遗失的数据print(NaN == True)print(NaN == False)print(NaN == 0)print(NaN == '')#通过函数来判断是否是NaNx = NaNy = NaNn= 20prin...原创 2019-10-01 13:52:56 · 326 阅读 · 0 评论