python dataframe

import pandas as pd
import numpy as np
from pandas import Series,DataFrame
import  re
# df=DataFrame({'name':['a','a','b','b','b'],'classes':[1,2,3,4,4],'price':[11,22,33,44,44]})
# print(df)

# #根据index和columns取值
# s=df.loc[0,'price']
# print(s)

#根据同行的columns的值取同行的另一个columns的值
# sex=df.loc[(df.classes==1)&(df.name=='a'),'price']
# print(sex)

# sex=df[(df.classes==1)&(df.name=='a')]['price'].values[0]
# print(sex)

# sex=df.loc[(df.classes==1)&(df.name=='a'),'price'].values[0]
# print(sex)



# #根据条件同时取得多个值
# name,price=df.loc[df.classes==1,('name','price')].values[0]
# print(name)
# print(price)
#
# # 对一列赋值
# df.loc[:,'price']=0
# print(df)
#
# df['price']=0  #df[:,'price']=0运行不了
# print(df)

# df.loc['price']=0  #df[:,'price']=0运行不了
# print(df)
#
# # 对df的一个列进行函数运算
#
# df['name']=df['name'].apply(lambda x:x.upper())
# print(df)
# #
# #
# df.loc[:,'name']=df['name'].apply(lambda x:x.upper())
# print(df)
#
# # 对df的几个列进行函数运算
#
# df[['classes','price']]=df[['classes','price']].applymap(lambda x:str(x))
# print(type(df.loc[0,"classes"]))
# print(df.loc[0,"classes"])
#
#
# df.loc[:,['classes','price']]=df[['classes','price']].applymap(lambdax:int(x))
# print(type(df.loc[0,"classes"]))
# print(df.loc[0,"classes"])
#
#
# # 对两个列进行去重
# print(df)
#
#
# df.drop_duplicates(subset=['classes','name'],inplace=True)
# print(df)

# df.drop_duplicates(subset=['classes','name'],inplace=False)
# print(df)

# aa=df.drop_duplicates(subset=['classes','name'],inplace=False)
# print(aa)
# print(df)

#
# # 多个条件分割字符串
# fund_memeber='赵四、[赵四、王五]王五'
# fund_manager_list=re.split('[；，、]',fund_memeber)
# print(fund_manager_list)
#
# #DataFrame构造器
# df=DataFrame({'x':[1],'y':[2]})
# print(df)
#
#
# # 删除某列值为特定值得那一行
df=DataFrame({'name':['a','b','c','d'],'classes':[1,2,3,4],'price':[11,22,33,44]})
print(df)
#
# 【方法一】
# df=df.loc[df['name']!='a']
# print(df)

# df=df[df['name']!='a']
# print(df)

# 【方法二】
# df.drop(df[df.name=='a'].index,axis=0)

#
# #筛选df的每列值包含某个字段‘/a’
#
# df=pd.DataFrame({'a':['A','B'],'b':['AA','BB']})
# print(df)
#
# print(df[df['a'].str.contains(r'A')])
#
#
df=pd.DataFrame({'a':['/api/','B'],'b':['AA','BB']})
print(df)


print(df[df['a'].str.contains(r'/api/')])
#
#