awsome. now how do i edit or sort these tables? iv'e been struggling non stop... i'm getting blank spaces everywhere when i edit or try to sort things...
yeah that was my first thought too, but it doesn't stay consistent from that point on...i almost think it has to do with page edits... like if a table is removed the number is removed but that index number can't be used again because it's saved for reversions or something
It worked for all the tables on the page except for the one I needed. The XPath had multiple div and ended with table no number. I tried all numbers from 0 to 6 and got the other tables. :( Bummer.
so the google search shows this video timestamped at 2m in and you dont even include the string in your description ! what do you think this is the 1980's where people type in programs from teh magazines !
Thanks! This video saved me a lot of time!
Brill!!!! Thanks Brian :)
Thank you! Subscribed
great! thank you!
Daniel Cormier! Great fighter
It did indeed help.
Isn't the first table number '0' therefore making the 4th table number '3'?
i thought that might be it too... but that doesn't stay true for all tables I've tried
Thank you
Thanks a lot!
glad it helped
Great, thank you.
no problem
awsome. now how do i edit or sort these tables? iv'e been struggling non stop... i'm getting blank spaces everywhere when i edit or try to sort things...
amazing function, it worked using ; instead of , for me though
oh interesting
In code, numbers go from '0' onwards so that's probably why it says table 3
yeah that was my first thought too, but it doesn't stay consistent from that point on...i almost think it has to do with page edits... like if a table is removed the number is removed but that index number can't be used again because it's saved for reversions or something
It worked for all the tables on the page except for the one I needed. The XPath had multiple div and ended with table no number. I tried all numbers from 0 to 6 and got the other tables. :( Bummer.
Did you figure out how to get that table?
getting stars for all the data *Head in the Clouds* like this what should i do
can u make a video of webscraping a table in python
wish i knew how. that's over my head
not working Formula parse error. even i do the same example;/
Try to use ";" instead of "," to separate the elements
@@thekillerregs6038 it worked. thank you a lot
thanks for helping out folks... hope this helped OP and others
so the google search shows this video timestamped at 2m in and you dont even include the string in your description ! what do you think this is the 1980's where people type in programs from teh magazines !
yup
can one cell import all tables in wik*? like : =importhtml("en.wikipedia.org/wiki/Daniel_Cormier" , "table" , 3+4) or something