转帖一个好文 excel 操作
https://shazhenyu.blog.csdn.net/article/details/83104653?utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromMachineLearnPai2%7Edefault-12.baidujs&dist_request_id=1331645.9688.16183693663790175&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromMachineLearnPai2%7Edefault-12.baidujs
import openpyxl
import xlrd
import xlwt
from xlutils.copy import copy
from decimal import Decimal
import pandas as pd
import numpy as np
显示所有列
pd.set_option(‘display.max_columns’, None)
显示所有行
np.set_printoptions(threshold = np.inf)
若想不以科学计数显示:
np.set_printoptions(suppress = True)
df = pd.read_excel(“/Volumes/C/Jmp_data/Python/Print IPA python analysis/IPA2_07-09-2019 13-57-33.xlsx”)
df[‘newclumn’] = df[“A”]*2
df[‘lowcase_Device’] = df[‘Device’].apply(lambda Device: Device.lower())
df[“Job ID”]=df[“Job ID”].replace(7834,1)
print(df)
Original: https://blog.csdn.net/qq_38844711/article/details/115692907
Author: SamWang_333
Title: 如何使用 pandas 操作 excel 并显示dataframe多行， 全列
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/678289/
转载文章受原作者版权保护。转载请注明原作者出处！