python3.8处理excel表

搭建python开发excel的环境：

pip install xlrd
pip install pandas
pip install pandas -i http://pypi.douban.com/simple/ --trusted-host pypi.douban.com
pip install openpyxl

处理excel表

import pandas as pd
import random
from pandas import DataFrame

data =pd.read_excel('G:/development-java/111.xlsx',sheet_name='001')

print(random.randint(0,9999))

times = 0
location = 1
size = 2
while location <= 10000 and times < 500:

    data.loc[location, 'cc'] = 20200907 #默认随机值
    location = location + size

    data.loc[location, 'ac'] = 20200907 #默认随机值
    location = location + size

    data.loc[location, 'pn'] = 20200907 #默认随机值
    location = location + size

    data.loc[location, 'nm'] = "hello nm" #默认随机值
    location = location + size

    data.loc[location, 'str'] = "hello str" #默认随机值
    location = location + size

    data.loc[location, 'ct'] = "hello ct" #默认随机值
    location = location + size

    data.loc[location, 'zip'] = "hello zip" #默认随机值
    location = location + size

    times = times + 1
else:
    print("over")

print(times)

#保存
DataFrame(data).to_excel('G:/development-java/222.xlsx', sheet_name='003', index=False, header=True)

d

 

import pandas as pd
import random
from pandas import DataFrame

data =pd.read_excel('G:/development-java/111.xlsx',sheet_name='001')

print(random.randint(0,9999))

times = 0
location = 1
size = 2
while location <= 10000 and times <= 500:

    data.loc[location, 'cc'] = 20200907 #默认随机值
    location = location + 2

    data.loc[location, 'ac'] = 20200907 #默认随机值
    location = location + 2

    data.loc[location, 'pn'] = 20200907 #默认随机值
    location = location + 2

    data.loc[location, 'nm'] = "hello nm" #默认随机值
    location = location + 2

    data.loc[location, 'str'] = "hello str" #默认随机值
    location = location + 2

    data.loc[location, 'ct'] = "hello ct" #默认随机值
    location = location + 2

    data.loc[location, 'zip'] = "hello zip" #默认随机值
    location = location + 2

    times = times + 1
else:
    print("over")

print(times)



#cc	    ac	pn	        nm	    str	    ct	zip



#查看所有的值
#print(data.values)

#print("------------------------------------------------")

#查看第一行的值
#print(data.values[0])

#print("------------------------------------------------")

#查看某一列所有的值
#print(data['nm'].values)

#print("------------------------------------------------")

#修改行
#print(data.values[4])
#data.values[4]
#data.loc[4, 'cc'] = 9979
#print(data.values[4])
#data.loc[4] = [99, 99, 44444, 'xixi', 'lala', 'xxx', 9090]

#print("------------------------------------------------")

#删除行：axis=0
#data = data.drop([0,1], axis=0)

#print("------------------------------------------------")

#保存
DataFrame(data).to_excel('G:/development-java/222.xlsx', sheet_name='003', index=False, header=True)