Hello Guys! I am wondering How can one check the number of columns of a table in SQLite when working in Jupyter locally?
I know that running the code below will show the number of rows:
%%sql
SELECT COUNT(*)
FROM <table_name_here>;
What line of codes will work to get the number of columns?
And is it possible to check and get the number of rows and columns in a table at the same time, like we can do with pandas DataFrame by running just the code:
DataFrame.shape --> returns number of rows and columns at the same time.
Thank you all for responses in advance!!!