Pandas
AaronCosmos
Stay hungry,stay foolish!
展开
-
【Bug排查分析】The truth value of a Series is ambiguous.Use a.empty(),a.bool(),a.item(),a.any() or a.all()
pandas bug处理原创 2022-07-01 14:45:36 · 1962 阅读 · 1 评论 -
pandas穷举与迭代方法
import pandas as pdimport numpy as npimport itertoolsl1=['a','b','c']l2=['1','2','3']l3=['A','B','C']a=[list(i) for i in itertools.product(l1, l2,l3)]data = pd.DataFrame(a)原创 2021-08-26 09:20:36 · 185 阅读 · 0 评论 -
Pandas的透视与逆透视操作
import pandas as pdimport numpy as np%matplotlib inlinedf=pd.read_csv('pandas_pivot_pra.csv')df.columns=['A','B','C','D','E']df#逆透视df1=df.melt(id_vars='A',value_vars=['B','C','D','E'])df1#透视df2=pd.pivot_table(df1,index=['A'],columns=['variabl原创 2021-07-09 13:59:57 · 711 阅读 · 0 评论 -
Pandas处理时间戳
import pandas as pdimport numpy as npimport time#方法一:df=pd.read_csv('xxx.csv')df.loc[:, 'a.st_time_e']=df['a.st_time_e'].astype('float64').apply(lambda x : time.localtime(x))#方法二:df3.loc[:, 'a.st_time_e'] = df3['a.st_time_e'].apply(lambda x :time.原创 2021-04-30 15:52:24 · 316 阅读 · 2 评论 -
Pandas查询list获取每行的标签
有的时候需要给每条数据打标签,通过查询另外一个表单获取当前数据条的标签值【示例】:test_dict = {'id':[1,2,3,4,5,6], 'name':['Alice','Bob','Cindy','Eric','Helen','Grace '], 'math':[90,89,99,78,97,93], 'english':[89,94,80,94,94,90]}#[1].直接写入参数test_dicttest_原创 2021-04-29 09:32:39 · 1448 阅读 · 0 评论 -
pandas中isin()函数
>>> df['E']=['a','a','c','b']>>> df A B C D E0 -0.018330 2.093506 -0.086293 -2.150479 a1 0.104931 -0.271810 -0.054599 0.361612 a2 0.590216 0.218049 0.157213 0.643540 c3 -0.254449 -0.59327.转载 2021-02-26 09:56:10 · 3016 阅读 · 0 评论 -
Python将字典数据逐行逐列逐元素添加到DataFrame中
示例:train={'K001':[[1,2,3],[4,5,6],[7,8,9]],'K002':[[4,5,8],[5,5,6],[4,3,6]] }df1=pd.DataFrame(columns=('a','b','c'))for i in train.keys(): for h in range(len(train[i])): data1=train[i][...原创 2020-04-17 11:10:35 · 3170 阅读 · 0 评论 -
Pandas查找特定行
import numpy as npimport pandas as pdimport randomrnd_1 = [random.randrange(1,20) for x in range(1000)]rnd_2 = [random.randrange(1,20) for x in range(1000)]rnd_3 = [random.randrange(1,20) for x ...原创 2019-12-07 13:23:00 · 4456 阅读 · 0 评论 -
Pandas中复制dataframe中的每一行
Pandas的一些练习// An highlighted blockimport numpy as npimport pandas as pdar1=np.arange(25).reshape(5,5)data1=pd.DataFrame(ar1) ar2=for i in range(5):原创 2018-12-07 23:31:17 · 16805 阅读 · 3 评论