十分钟入门Pandas

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import openpyxl
import xlrd

# 一、创建数据
s = pd.Series([1,3,5,np.nan,6,8])
s

0    1.0
1    3.0
2    5.0
3    NaN
4    6.0
5    8.0
dtype: float64

# 创建DataFrame
dates = pd.date_range("20130101",periods = 6)
df = pd.DataFrame(np.random.randn(6,4),index=dates,columns=list("ABCD"))
df

	A	B	C	D
2013-01-01	0.028291	-0.492346	0.269306	-0.648454
2013-01-02	-0.159334	0.182519	-0.725038	-0.296117
2013-01-03	-1.234608	0.011890	0.280217	-0.089411
2013-01-04	1.498667	-0.721514	0.960158	0.746701
2013-01-05	0.278952	-0.617474	0.397837	0.173264
2013-01-06	-1.347493	-1.649745	-1.212531	1.568684