版本:
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 pdif __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.0for 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'))]})# 保存 dataframedf.to_csv('Test.csv')df.to_excel('site.xlsx', index=False, engine='openpyxl')df.to_excel('site.xls', index=False, engine='xlwt')