from streamlit_option_menu import option_menu
import pandas as pd
import streamlit as st
from st_aggrid import AgGrid
from st_aggrid.grid_options_builder import GridOptionsBuilder
from st_aggrid.shared import ColumnsAutoSizeMode
from st_aggrid import GridOptionsBuilder, AgGrid, GridUpdateMode
import streamlit.components.v1 as components

custom_css = {
    ".ag-row-hover": {"background-color": "#98FB98 !important"},
    ".ag-row-odd": {"background-color": "#FFF8DC"},
    ".ag-row-even": {"background-color": "#D2B48C"},
    ".ag-root-wrapper": {"border": "3px solid #98FB98"},
    ".ag-header": {"background-color": "#2c2d30"},
    ".ag-status-bar": {"background-color": "#232323"},
    ".ag-right-cols-container": {"background-color": "#98FB98"},
    ".ag-side-buttons": {"background-color": "#2c2d30"},
    ".ag-paging-panel": {"background-color": "#98FB98"},
    ".ag-root": {"background-color": "#98FB98"},
    ".ag-cell-focus .ag-cell-value": {"background-color": "#4895ef !important"},
    ".ag-root": {"background-color": "#98FB98"},
    ".ag-cell-focus .ag-cell-value": {"background-color": "#4895ef !important"},
    ".ag-row-selected": {"color": "#4895ef !important"},
    ".ag-theme-streamlit": {'transform': "scale(0.8)", "transform-origin": '0 0'}
}

components.iframe("https://www.mixdiy.com/",650,800)


df = pd.read_excel(r"C:\Users\1\Downloads\ab.xls")

#gb = GridOptionsBuilder.from_dataframe(df, min_column_width=100)
#AgGrid(df, gridOptions=gb.build(), fit_columns_on_grid_load=True)

other_options = {'suppressColumnVirtualisation': True}
gb = GridOptionsBuilder.from_dataframe(df)
gb.configure_pagination(paginationAutoPageSize=True)
gb.configure_grid_options(**other_options)
gridOptions = gb.build()
AgGrid(df,gridOptions,columns_auto_size_mode=ColumnsAutoSizeMode.FIT_CONTENTS,custom_css=custom_css)
hide_streamlit_style = """
                        <style>
                        #MainMenu {visibility: hidden;}
                        footer {visibility: hidden;}
                        </style>
"""
st.markdown(hide_streamlit_style, unsafe_allow_html=True)

WSL2: Temporary Failure in Name Resolution

In WSL2, run:

登录后复制 
# remove existing resolv.conf symlink that is pointing to a wrong nameserver
sudo rm /etc/resolv.conf
# create a new resolv.conf with a correct nameserver
sudo bash -c 'echo "nameserver 1.1.1.1" > /etc/resolv.conf'
# stop wsl from regenerating resolv.conf symlink
sudo bash -c 'printf "[network]\ngenerateResolvConf = false" > /etc/wsl.conf'
# make current resolv.conf immutable so that wsl does not delete it
sudo chattr +i /etc/resolv.conf



In powershell, run

wsl --shutdown
wsl

出现问题No module named pip的解决
sudo apt update
sudo apt upgrade -y
sudo apt install --fix-missing python3-pip

Windows 11 安装 WSL2 – 知乎 (zhihu.com)

Tkinter GUI Designer Tutorial (Figma to Tkinter)

streamlit run app.py --server.port 80

以上以80端口运行

import numpy as np
import pandas as pd
import streamlit as st
x = st.slider("选择一个数字", 0, 100)
st.write(x, "的平方是", x * x)

chart_data = pd.DataFrame(
    np.random.randn(20, 3),
    columns = ['a', 'b', 'c'])

st.area_chart(chart_data)

hide_streamlit_style = """
<style>
#MainMenu {visibility: hidden;}
footer {visibility: hidden;}
</style>
"""
st.markdown(hide_streamlit_style, unsafe_allow_html=True)

以上代码隐藏了streamlit的logo

grep -rn “apt.v2raya.mzz.pub”

这是树莓派官方操作系统Raspberry Pi OS (64-bit)的配置程序

请下载对应自己操作系统的压缩文件，这里以64位树莓派官方操作系统为例

下载文件后解压

unzip pimateone64.zip

解压后在解压文件所在目录以su用户运行

sudo ./pimateone64

配置程序执行完毕后系统会自动重启，等待树莓派启动后即可使用mateone按钮实现树莓派的正常开关机。

注意：树莓派关机需要一定时间，关机过程中不要按下mateone的按键（按下了也不起作用😊）

附：查看自己的系统类型

getconf LONG_BIT

返回64，即为64位系统，对应本文的例子。返回32，即为32位系统，需下载pimateone32

c程序