没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
F M A
Data$Wrangling$
!"#$%&'()'*%
+$,'#%-$,,#%
$.&/00&'()'*1&2)'#'1345%
Syntax%6%+4,'7(5%8'#'94':,*%
Tidy$Data$6%;%<3=()'73(%<34%!4'(5>"(5%"(%&'()'*%
?(%'%7)2%
)'#'%*,#/%
F M A
@'A$%variable%"*%*'B,)%
"(%"#*%3!(%column$
C%
@'A$%observa8on$"*%
*'B,)%"(%"#*%3!(%row$
D")2%)'#'%A3:&>,:,(#*%&'()'*E*%vectorized$
opera8ons1%&'()'*%!">>%'=#3:'7A'>>2%&4,*,4B,%
3F*,4B'73(*%'*%23=%:'("&=>'#,%B'4"'F>,*1%G3%
3#$,4%<34:'#%!34H*%'*%"(#="7B,>2%!"#$%&'()'*1$
Reshaping$Data%6%+$'(5,%#$,%>'23=#%3<%'%)'#'%*,#%
M A F
*"
M" A"
*"
pd.melt(df)+
%%I'#$,4%A3>=:(*%"(#3%43!*1%
df.pivot(columns='var',+values='val')+
%%-&4,')%43!*%"(#3%A3>=:(*1%
pd.concat([df1,df2])+
%%;&&,()%43!*%3<%8'#'94':,*%
pd.concat([df1,df2],+axis=1)+
%%;&&,()%A3>=:(*%3<%8'#'94':,*%
df.sort_values('mpg')+
J4),4%43!*%F2%B'>=,*%3<%'%A3>=:(%K>3!%#3%$"5$L1%
%
df.sort_values('mpg',ascending=False)+
J4),4%43!*%F2%B'>=,*%3<%'%A3>=:(%K$"5$%#3%>3!L1%
%
df.rename(columns+=+{'y':'year'})+
M,(':,%#$,%A3>=:(*%3<%'%8'#'94':,%
%
df.sort_index()+
-34#%#$,%"(),N%3<%'%8'#'94':,%
%
df.reset_index()+
M,*,#%"(),N%3<%8'#'94':,%#3%43!%(=:F,4*O%:3B"(5%
"(),N%#3%A3>=:(*1%
%
df.drop(['Length','Height'],+axis=1)+
%%%%%843&%A3>=:(*%<43:%8'#'94':,%
Subset$Observa8ons$KM3!*L% Subset$Variables$K+3>=:(*L%
a$ b$ c$
1$
P% Q% RS%
2$
T% U% RR%
3$
V% W% RX%
df+=+pd.DataFrame(+
++++++++++{"a"+:+[4+,5,+6],++
+++++++++++"b"+:+[7,+8,+9],++
+++++++++++"c"+:+[10,+11,+12]},+++++
++++++++index+=+[1,+2,+3])+
%%-&,A"<2%B'>=,*%<34%,'A$%A3>=:(1%
%
df+=+pd.DataFrame(+
+++++[[4,+7,+10],+
++++++[5,+8,+11],+
++++++[6,+9,+12]],++
+++++index=[1,+2,+3],++
+++++columns=['a',+'b',+'c'])+
%%-&,A"<2%B'>=,*%<34%,'A$%43!1%
a$ b$ c$
n$ v$
d$
1$
P% Q% RS%
2$
T% U% RR%
e$ 2$
V% W% RX%
df+=+pd.DataFrame(+
++++++++++{"a"+:+[4+,5,+6],++
+++++++++++"b"+:+[7,+8,+9],++
+++++++++++"c"+:+[10,+11,+12]},++++
index+=+pd.MultiIndex.from_tuples(+
++++++++++[('d',1),('d',2),('e',2)],+
+++++++++++++names=['n','v'])))+
%%+4,'#,%8'#'94':,%!"#$%'%Y=>7?(),N%
Method$Chaining%
Y3*#%&'()'*%:,#$3)*%4,#=4(%'%8'#'94':,%*3%#$'#%
'(3#$,4%&'()'*%:,#$3)%A'(%F,%'&&>",)%#3%#$,%
4,*=>#1%%D$"*%":&43B,*%4,')'F">"#2%3<%A3),1+
df+=+(pd.melt(df)+
++++++++.rename(columns={+
++++++++++++++++'variable'+:+'var',+++
++++++++++++++++'value'+:+'val'})+
++++++++.query('val+>=+200')+
+++++)+
df[df.Length+>+7]+
@N#4'A#%43!*%#$'#%:,,#%>35"A'>%
A4"#,4"'1%
df.drop_duplicates()+
M,:3B,%)=&>"A'#,%43!*%K3(>2%
A3(*"),4*%A3>=:(*L1%
df.head(n)+
-,>,A#%Z4*#%(%43!*1%
df.tail(n)+
-,>,A#%>'*#%(%43!*1%
Logic$in$Python$(and$pandas)$
<+ [,**%#$'(% !=+ G3#%,\='>%#3%
>+ I4,'#,4%#$'(% df.column.isin(values)+ I43=&%:,:F,4*$"&%
==+ @\='>*% pd.isnull(obj)+ ?*%G'G%
<=+ [,**%#$'(%34%,\='>*% pd.notnull(obj)+ ?*%(3#%G'G%
>=+ I4,'#,4%#$'(%34%,\='>*% &,|,~,^,df.any(),df.all()+ [35"A'>%'()O%34O%(3#O%N34O%'(2O%'>>%
$.&/00&'()'*1&2)'#'13450%%D$"*%A$,'#%*$,,#%"(*&"4,)%F2%M*#=)"3%8'#'%]4'(5>"(5%+$,'#*$,,#%K$.&*/00!!!14*#=)"31A3:0!&^A3(#,(#0=&>3')*0XSRT0SX0)'#'^!4'(5>"(5^A$,'#*$,,#1&)<L%%]4".,(%F2%?4B%[=*75O%_4"(A,#3(%+3(*=>#'(#*%
df[['width','length','species']]+
%%%%%-,>,A#%:=>7&>,%A3>=:(*%!"#$%*&,A"ZA%(':,*1%
df['width']++or++df.width+
%%%%%-,>,A#%*"(5>,%A3>=:(%!"#$%*&,A"ZA%(':,1%
df.filter(regex='regex')+
%%%%%-,>,A#%A3>=:(*%!$3*,%(':,%:'#A$,*%4,5=>'4%,N&4,**"3(%regex1+
df.loc[:,'x2':'x4']+
%%%%%-,>,A#%'>>%A3>=:(*%F,#!,,(%NX%'()%NP%K"(A>=*"B,L1%
df.iloc[:,[1,2,5]]+
%%%%%-,>,A#%A3>=:(*%"(%&3*"73(*%RO%X%'()%T%KZ4*#%A3>=:(%"*%SL1%
df.loc[df['a']+>+10,+['a','c']]+
%%%%%-,>,A#%43!*%:,,7(5%>35"A'>%A3()"73(O%'()%3(>2%#$,%*&,A"ZA%A3>=:(*%1%
regex$(Regular$Expressions)$Examples$
'\.'+ Y'#A$,*%*#4"(5*%A3(#'"("(5%'%&,4"3)%`1`%
'Length$'+ Y'#A$,*%*#4"(5*%,()"(5%!"#$%!34)%`[,(5#$`%
'^Sepal'+ Y'#A$,*%*#4"(5*%F,5"(("(5%!"#$%#$,%!34)%`-,&'>`%
'^x[1-5]$'+ Y'#A$,*%*#4"(5*%F,5"(("(5%!"#$%`N`%'()%,()"(5%!"#$%ROXOaOPOT%
''^(?!Species$).*'+ Y'#A$,*%*#4"(5*%,NA,&#%#$,%*#4"(5%`-&,A",*`%
df.sample(frac=0.5)+
M'()3:>2%*,>,A#%<4'A73(%3<%43!*1%%
df.sample(n=10)+
%%%%%M'()3:>2%*,>,A#%(%43!*1%
df.iloc[10:20]+
%%%%%-,>,A#%43!*%F2%&3*"73(1%
df.nlargest(n,+'value')+
%%%%%-,>,A#%'()%34),4%#3&%(%,(#4",*1%
df.nsmallest(n,+'value')+
-,>,A#%'()%34),4%F3.3:%(%,(#4",*1%
资源评论
summerfoliage
- 粉丝: 0
- 资源: 10
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功