工作记录jkfjdkfj

# coding=utf-8
import os

front_count = 0
back_count = 0

frontHanstoBag = 0
frontHanstoBagTrue = 0
frontHanstoBagFalse = 0

listALL = []
listTemp = []
i = 0
with open('IO.txt', 'r') as f:
    f.seek(0, 0)
    strLines = f.readlines()
    while i < len(strLines):
        if strLines[i].find("th",0,3) != -1:
            if len(listTemp) == 0:
                listTemp.insert(0,strLines[i])
                i += 1
            else:
                listTemp.append(strLines[i])
                i += 1

        while i <= len(strLines):
            if i > len(strLines) - 1:
                listALL.append(listTemp.copy())
                break
            if strLines[i].find('th',0,3) == -1:
                listTemp.append(strLines[i])
                i += 1
            else:
                listALL.append(listTemp.copy())
                listTemp.clear()
                break

print(listALL)

for item in listALL:
    for item2 in item:
        if item2.find("th",0,3) != -1:
            front_count += 1
            if item2.find('正向') != -1 and item2.find("把手放进裤子口袋") != -1:
                frontHanstoBag += 1

file = 0
path = 'count.txt'
if not os.path.exists(path):
    file = open(path, 'w')
    try:
        file.write(f'front_count={front_count}\n')
        file.write(f'frontHanstoBag={frontHanstoBag}\n')
    except IOError:
        print('IOError')
else:
    file = open(path, 'w')
    try:
        file.write(f'front_count={front_count}\n')
        file.write(f'frontHanstoBag={frontHanstoBag}\n')
    except IOError:
        print('IOError')
file. Close()




#csv文件操作
import csv
#写入csv文件
# 假设data是一个包含数据的二维列表
data = [
    ['姓名', '年龄', '性别'],
    ['张三', 25, '男'],
    ['李四', 30, '女']
]

# 保存CSV文件时指定使用UTF-8-sig编码，不让excel打开可能有乱码
with open('output.csv', 'w', newline='', encoding='utf-8-sig') as file:
    writer = csv.writer(file)
    writer.writerows(data)



#导入csv库并打开CSV文件：
with open('data.csv', 'r') as file:
    reader = csv.reader(file)
    data = list(reader)

#合并指定范围内的单元格数据：
start_row = 1
end_row = 3
start_col = 1
end_col = 2

for row in range(start_row, end_row):
    for col in range(start_col, end_col):
        data[row][col] = ','.join(data[row][start_col:end_col])

#
with open('output.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerows(data)


#示例
import csv

# 读取第一个CSV文件
data1 = []
with open('file1.csv', 'r', newline='') as file1:
    reader = csv.reader(file1)
    for row in reader:
        data1.append(row)

# 读取第二个CSV文件
data2 = []
with open('file2.csv', 'r', newline='') as file2:
    reader = csv.reader(file2)
    for row in reader:
        data2.append(row)

# 指定要合并的行和列
merge_row = 1
merge_col = 2

# 合并指定单元格内容
merged_data = []
for i in range(max(len(data1), len(data2))):
    row1 = data1[i] if i < len(data1) else [''] * len(data1[0])
    row2 = data2[i] if i < len(data2) else [''] * len(data2[0])

    merged_row = []
    for j in range(max(len(row1), len(row2)):
        if i == merge_row and j == merge_col:
            merged_row.append(row1[j] + ', ' + row2[j])  # 合并单元格内容
        else:
            cell1 = row1[j] if j < len(row1) else ''
            cell2 = row2[j] if j < len(row2) else ''
            merged_row.append(cell1 + ', ' + cell2)

    merged_data.append(merged_row)

# 写入合并后的数据到新的CSV文件
with open('merged_file.csv', 'w', newline='') as merged_file:
    writer = csv.writer(merged_file)
    writer.writerows(merged_data)

print("CSV文件中指定单元格内容已合并完成。")