Python method to extract HTML page strings and convert them into data frames
P粉691461301
2023-08-16 13:28:27
<p>I have an HTML page that contains a string. I want to convert it to dataframe. Rows in this string are separated by a space that is not inside quotes (there are spaces between quotes in column values). </p>
<p>Page link: https://gladys.geog.ucl.ac.uk/bikesapi/load.php?scheme=saopaulo</p>
<p>I know this is a common question, but if this is an exact duplicate with the same problem and solution, could you please send me the link? I tried several solutions but none matched my problem. </p>
Try using
pd.read_csv
:Output result: