You can use Beem

pip install beem

Of course you need pandas as well.

pip install pandas as pd

You can take your results from either HiveSQL or any public node into a dataframe.

df = pd.DataFrame(list_of_data)

You can use Beem to interact with Hive nodes, you can find the docs here