pip install pandas
pip install xlrd
pip install openpyxl

# 1、安裝包
$ pip install pandas

# 2、進(jìn)入python的交互式界面
$ python -i

# 3、使用Pandas
>>> import pandas as pd
>>> df = pd.DataFrame() 
>>> print(df)

# 4、輸出結(jié)果
Empty DataFrame
Columns: []
Index: []

import  pandas  as pd
from pandas import DataFrame

#創(chuàng)建DataFrame可以用下面字典，也可以用數(shù)組ndarray
dic = {'標(biāo)題列1': ['malena','morgan'],
        '標(biāo)題列2': [36, 34]
       }
df = pd.DataFrame(dic)
df.to_excel('write_test.xlsx', index=False)

import pandas as pd
from pandas import DataFrame

df.to_excel('foo.xlsx', sheet_name='Sheet1')

 pd.read_excel('foo.xlsx', 'Sheet1', index_col=None, na_values=['NA'])

pip uninstall xlrd
pip install xlrd==1.2.0

df=pandas.read_excel(‘data.xlsx',engine=‘openpyxl')

data = pd.read_excel('zmy-weekly.xlsx', sheet_name='3月', engine='openpyxl')
print(data)

 data.loc[3][2] = '工作事項(xiàng)5';

 DataFrame(data).to_excel('new.xlsx', sheet_name='3月', index=False, header=True)

import pandas as pd
from pandas import DataFrame

# 3.8.2 pandas讀寫(xiě)Excel
def write_weekly():
    data = pd.read_excel('zmy-weekly.xlsx', sheet_name='3月', engine='openpyxl')
    print(data)

    print(data.loc)

    data.loc[2][0] = '3月5周';
    data.loc[2][2] = '工作事項(xiàng)4';
    data.loc[3][2] = '工作事項(xiàng)5';
    data.loc[4][2] = '工作事項(xiàng)6';

    data.loc[2][4] = '已完成';
    data.loc[3][4] = '已完成';
    data.loc[4][4] = '已完成';

    data.loc[5][2] = '又是一個(gè)臨時(shí)工作';


    data.loc[6][0] = '4月1周';

    data.loc[6][2] = '工作事項(xiàng)7';
    data.loc[7][2] = '工作事項(xiàng)8';

    data.loc[6][4] = '進(jìn)行中';
    data.loc[7][4] = '進(jìn)行中';

    # # 保存數(shù)據(jù)
    DataFrame(data).to_excel('new.xlsx', sheet_name='3月', index=False, header=True)


write_weekly();