有没有一种方法可以从Google Sheet中的特定颜色编码行创建DataFrame？(广播网和熊猫网)

import pandas as pd

import gspread
from oauth2client.service_account import ServiceAccountCredentials

# 设置OAuth2凭证
scope = ['https://spreadsheets.google.com/feeds',
         'https://www.googleapis.com/auth/drive']
credentials = ServiceAccountCredentials.from_json_keyfile_name('credentials.json', scope)
client = gspread.authorize(credentials)

# 打开Google Sheet
sheet = client.open('Google Sheet名称').sheet1

# 读取所有行数据
rows = sheet.get_all_records()

for row in rows:
    cell = sheet.cell(row=row['行号'], col='列号')
    cell_format = cell.format
    background_color = cell_format.get('backgroundColor')

    # 检查特定颜色编码
    if background_color == '颜色编码':
        # 处理符合条件的行

data = []

for row in rows:
    cell = sheet.cell(row=row['行号'], col='列号')
    cell_format = cell.format
    background_color = cell_format.get('backgroundColor')

    if background_color == '颜色编码':
        data.append(row)

df = pd.DataFrame(data)