import numpy
import matplotlib
from matplotlib import pyplot as plt
from matplotlib.pyplot import MultipleLocator
import openpyxl
from openpyxl import workbook
import os
import operator
#=============================读取excel中的加速度记录==================
work_directory = "F:\王子铭文件\土耳其地震\土耳其地震/N excel"
file_name = os.listdir(work_directory)
for t in range(0,len(file_name)):
gm = []
gm_changed = []
path = "F:\王子铭文件\土耳其地震\土耳其地震/N excel/" + file_name[t]
wb_1 = openpyxl.load_workbook(path)
sheet_name = wb_1.sheetnames
sheet = wb_1[sheet_name[1]]
time = numpy.arange(0, int((sheet.max_row - 63)) / 100, 0.01)
for i in numpy.arange(63, sheet.max_row):
gm.append(sheet.cell(i, 1).value)
批量出地震动时程曲线
最新推荐文章于 2024-08-19 14:41:29 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)