How to convert SQL Query result to PANDAS Data Structure?

by

Here’s the shortest code that will do the job:

from pandas import DataFrame
df = DataFrame(resoverall.fetchall())
df.columns = resoverall.keys()

You can go fancier and parse the types as in Paul’s answer.

More Related Contents:

  1. How to insert pandas dataframe via mysqldb into database?
  2. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  3. Python Pandas write to sql with NaN values
  4. Python Pandas to_sql, how to create a table with a primary key?
  5. How to apply a function to two columns of Pandas dataframe
  6. How to convert an XML file to nice pandas dataframe?
  7. Dynamically evaluate an expression from a formula in Pandas
  8. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  9. Load data from txt with pandas
  10. Pandas index column title or name
  11. Making heatmap from pandas DataFrame
  12. Prepend a level to a pandas MultiIndex
  13. Vectorizing Haversine distance calculation in Python
  14. Make Pandas groupby act similarly to itertools groupby
  15. Python pandas – filter rows after groupby
  16. pandas dataframe, copy by value
  17. Use Multiple Character Delimiter in Python Pandas read_csv
  18. Updating value in iterrow for pandas
  19. Drop rows with all zeros in pandas data frame
  20. Boolean Series key will be reindexed to match DataFrame index
  21. how to merge two data frames based on particular column in pandas python?
  22. Anti-Join Pandas
  23. Get first row of dataframe in Python Pandas based on criteria
  24. Drop rows on multiple conditions in pandas dataframe
  25. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  26. Context manager for Python’s MySQLdb
  27. Merging two tables with millions of rows in Python
  28. Selecting a range of columns in a dataframe
  29. Pandas data frame to dictionary of lists
  30. Pandas min() of selected row and columns

Leave a Comment