from pandas import read_csv
df = read_csv("D:\\4.1\\data10.csv")
scale = (df.score-df.score.min())/(df.score.max()-df.score.min())
import pandas
from pandas import read_csv
df = read_csv("D:\\4.1\\data15.csv", sep='|')
bins = [min(df.cost)-1, 20, 40, 60, 80, 100, max(df.cost)+1]
labels = ['20以下', '20到40', '40到60', '60到80', '80到100', '100以上']
pandas.cut(df.cost, bins)
pandas.cut(df.cost, bins, right=False)
r = pandas.cut(df.cost, bins, right=False, labels=labels)
df['分组']= r
from pandas import read_csv
from pandas import to_datetime
from datetime import datetime
df = read_csv("D:\\4.1\\data16.csv")
df_dt = to_datetime(df.注册时间, format='%Y/%m/%d')
df_dt_str = df_dt.apply(lambda x: datetime.strftime(x, '%Y-%m-%d'))
df_dt.dt.year
df_dt.dt.second
df_dt.dt.minute
df_dt.dt.hour
df_dt.dt.day
df_dt.dt.month
df_dt.dt.weekday