- 95
- 7 576
AIgineer
Приєднався 11 січ 2014
I am an AIgineer with great passion for teaching within the world of mathematics, programming data and AI.
Common table expressions in DuckDB (coding)
Common table expressions in DuckDB (coding)
Переглядів: 28
Відео
Commont table expressions (CTE) in DuckDB
Переглядів 2112 годин тому
Commont table expressions (CTE) in DuckDB
Joins in SQL DuckDB to combine rows between several tables (coding)
Переглядів 66День тому
Joins in SQL DuckDB to combine rows between several tables (coding)
Joins in SQL DuckDB to combine rows between several tables
Переглядів 50День тому
Joins in SQL DuckDB to combine rows between several tables
Working with string and regexp in DuckDB (theory)
Переглядів 3514 днів тому
Working with string and regexp in DuckDB (theory)
Working with strings in SQL and DuckDB (coding)
Переглядів 8914 днів тому
Working with strings in SQL and DuckDB (coding)
Generating synthetic data using DuckDB SQL (coding)
Переглядів 11014 днів тому
Generating synthetic data using DuckDB SQL (coding)
DuckDB CLI to ingest data from csv file
Переглядів 10421 день тому
DuckDB CLI to ingest data from csv file
Course structure for modern SQL with DuckDB part 2 - github repository
Переглядів 7121 день тому
Course structure for modern SQL with DuckDB part 2 - github repository
Course structure for modern SQL with DuckDB
Переглядів 7721 день тому
Course structure for modern SQL with DuckDB
DBeaver connect with DuckDB with SQL introduction
Переглядів 12221 день тому
DBeaver connect with DuckDB with SQL introduction
Generating synthetic data using DuckDB (theory)
Переглядів 5621 день тому
Generating synthetic data using DuckDB (theory)
Querying data in DuckDB with SELECT statements (theory)
Переглядів 8821 день тому
Querying data in DuckDB with SELECT statements (theory)
Introduction to SQL and duckdb (theory)
Переглядів 12821 день тому
Introduction to SQL and duckdb (theory)
LIA series 1 - preboarding and onboarding students
Переглядів 118Місяць тому
LIA series 1 - preboarding and onboarding students
The content you shared was great, and I really appreciated the information. However, the audio quality could use a little improvement. If you haven't already, you might consider using a tool like Adobe's Enhance Speech feature to clean up the audio and make it sound clearer.
How to format st.dataframe with css like change the header color, and the background color of the table?
I am not sure if it is possible as the whole dataframe seem to be a div. However I found this in documentation docs.streamlit.io/develop/api-reference/data/st.dataframe it says that pandas styler object can be used for styling the dataframe, and here is documentation for pandas styler object pandas.pydata.org/docs/user_guide/style.html haven't tried it out, tell me if it works
Here is a minimal example, tried it out and it works import streamlit as st import pandas as pd df = pd.DataFrame({ 'Column 1': [1, 2, 3], 'Column 2': [4, 5, 6] }) def style_dataframe(df): return df.style.set_table_styles( [{ 'selector': 'th', 'props': [ ('background-color', '#4CAF50'), ('color', 'white'), ('font-family', 'Arial, sans-serif'), ('font-size', '16px') ] }, { 'selector': 'td, th', 'props': [ ('border', '2px solid #4CAF50') ] }] ) styled_df = style_dataframe(df) st.write(styled_df.to_html(), unsafe_allow_html=True) here is the source for the discussion discuss.streamlit.io/t/how-to-change-the-header-color-and-font-in-st-dataframe-and-st-data-editor/69676/2
Thank you for this best video on streamlit css on UA-cam 🙏
Thank you :)
The video got stuck from 06:00 to 07:23 minute , we can hear just sound.
Remember to add SELECT in the grants (missed in the video) so that job_ads_dlt_role can view the data as we're using that role to select the data later
Great video! The visuals really help my understanding
Thank you, you can find my other videos through my repo.