相干扩大库
1# -*- coding: UTF-8 -*-23# 导入扩大库45import pandas as pd67import numpy as np创立空DataFrame对象
1# 自定义列名创立空的DataFrame数据对象23df = pd.DataFrame(columns={"name": "", "age": "", "sex": "", "score": "", "rate": ""})45print(df)67# Empty DataFrame8# Columns: [name, age, sex, score, rate]9# Index: []数组创立DataFrame对象
1# 自定义数组创立DataFrame对象 2 3list_data = [['1', '2', '3']] 4 5df = pd.DataFrame(list_data, columns=['first', 'second', 'third']) 6 7print(df) 8 9# first second third10# 0 1 2 3字典创立DataFrame对象
1# 自定义字典类型的数据创立DataFarme对象 2 3data_dict = {'first_col': [1, 2, 3, 4], 'second_col': [5, 6, 7, 8]} 4 5df = pd.DataFrame(data_dict) 6 7print(df) 8 9# first_row second_row10# 0 1 511# 1 2 612# 2 3 713# 3 4 8文件返回DataFrame对象
1# 读取数据文件返回DataFrame对象23df=pd.read_csv('/usr/load/data.csv',split=',')45df=pd.read_csv('/usr/load/data.xls',sheet_name='data')67print(df)np创立DataFrame对象
1# 应用numpy科学计算库提供的二维数组创立DataFrame对象 2 3data_array = np.random.rand(4, 2) 4 5df = pd.DataFrame(data_array, columns=['first', 'second']) 6 7print(df) 8 9# first second10# 0 0.410413 0.51078811# 1 0.726956 0.64777512# 2 0.502573 0.22671413# 3 0.926117 0.124414更多精彩返回微信公众号【Python 集中营】，专一于 python 技术栈，材料获取、交换社区、干货分享，期待你的退出~