python2.7+pandas

版本：

Python 2.7.18 (v2.7.18:8d21aa21f2, Apr 20 2020, 13:25:05) [MSC v.1500 64 bit (AM
D64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>>

 

配套module:

测试案例：

# -*-coding:utf-8-*-

import pandas as pd

if __name__ == '__main__':
    # df = pd.read_excel(r'C:\Users\Administrator\PycharmProjects\pandas_project\data\Test.xlsx')
    df = pd.read_csv(r'C:\Users\Administrator\PycharmProjects\pandas_project\data\Test.csv')

    sum = 0.0
    for salary in df.get('Salary'):
        if str(salary) != 'nan':
            sum += float(salary)
    print sum / len(df.get('Salary'))

    df = pd.DataFrame({'Salary': [sum / len(df.get('Salary'))]})

    # 保存 dataframe
    df.to_csv('Test.csv')
    df.to_excel('site.xlsx', index=False, engine='openpyxl')
    df.to_excel('site.xls', index=False, engine='xlwt')