Максим Припадчев

def transform_range(old,new,t):
    a,b = old
    c,d = new
    return c + ((d-c) / (b-a)) * (t - a)
print(transform_range([1,9],[100,1],1))

whole_part  = html.find('strong',class_='f_Strong').big.text
float_part = html.find('strong',class_='f_Strong').big.next_sibling.strip()
print(whole_part + float_part)

users = [(surname), (name), (patronymic), (number)]

soup_all_templates.find_all(lambda tag: tag.name == 'a' and tag.get('class') == ['save-state'])

df['updated'] = pd.to_datetime(df['updated'],errors='coerce' )
df['created'] = pd.to_datetime(df['created'],errors='coerce' )
df['resolved'] = pd.to_datetime(df['resolved'],errors='coerce')

import requests
import browser_cookie3
import json
cookies = browser_cookie3.chrome()
dict_cookies = requests.utils.dict_from_cookiejar(cookies)
with open("cookies.json", "w") as f:
    json.dump(dict_cookies, f)

for row in soup.find_all('p')[0].text.split('/n'):
    print(row)

import pandas as pd
#создаю такую же таблицу как у тебя
df = pd.DataFrame({
    'Дата':['23-01-01','23-01-01','24-01-01','24-01-01'],
    'Часы':['10:00','11:00','10:00','11:00'],
    'Процент':[10.2,11.2,22.2,42.2],
    'Опрошенных':[20,27,40,12]
})
#само решение
reshaped_df = df.pivot(index=['Дата'],columns='Часы',values=['Процент','Опрошенных'])\
    .swaplevel(axis=1).T.reset_index()\
    .pivot(index='Часы',columns='level_1')
reshaped_df.columns.names = ['Дата',None]
print(reshaped_df)

import io
import pandas as pd


excel_file = io.BytesIO()
excel_file.name = "table_excel.xlsx"
all_frames = []
for history in ads:
    item_title = history.get("item_title")
    item_price = history.get("item_price")
    current_df = pd.DataFrame(
        {
            "Имя": [item_title],
            "Цена": [item_price],
        }
    )
    all_frames.append(currend_df)
final_df = pd.concat(all_frames, ignore_index=True)

final_df.to_excel(excel_file, encoding="utf-8", index=False)