Dataframe相关笔记
postgres链接查询
pip install sqlalchemy
pip install psycopg2
from sqlalchemy import create_engine
engine = create_engine('postgresql://postgres:123456@localhost:5432/postgres')
df = pd.read_sql("select * from table",engine)
数据分组后,多行并成一行数据
df_out = df.set_index(['名称',df.groupby(['名称']).cumcount()+1]).unstack().sort_index(level=1, axis=1)
df_out.columns = df_out.columns.map('{0[0]}_{0[1]}'.format)
df = df_out.reset_index()
字段类型转换(比较安全做法)
df_result['type'] = pd.to_datetime(df_result['type'] ,format='%d-%m月-%y')
Series 转字符串
",".join(result)
pandas读取excel指定字段类型
df = pd.read_excel('行业16.xlsx',dtype={'行业代码映射':str})