Pandas进阶用法—background_gradient、highlight、format等
数据导入
import matplotlib.pyplot as plt
import pandas as pd
import numpy as np
import seaborn as sns
# 导入数据
df = pd.DataFrame(pd.read_csv('C:/Users/Desktop/example.csv',encoding='gbk'))
# 转换日期格式
df['日期'] = pd.to_datetime(df["日期"])
# 对于数据格式进行了解
df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 55 entries, 0 to 54
Data columns (total 7 columns):
日期 55 non-null datetime64[ns]
项目 55 non-null object
城市 55 non-null object
展现 55 non-null int64
点击 55 non-null int64
线索 5 non-null float64
消费 5 non-null float64
dtypes: datetime64[ns](1), float64(2), int64(2), object(2)
memory usage: 2.6+ KB
透视表
# 数据整合
baidu_group = df.groupby(['日期','城市','项目']).agg({
'展现':'sum', '点击'