Python with mysql

Question

When we use fetchall in MySQL with python it returns data in tuple form but if o want that data in tabular form . What should I do ?

Answer 1

What is tabular form? That's not a data type in python

Answer 2

Hi, Om Yele !
Have you checked out Pandas. It’s a Python package that are suitable to realational or labeled data. To me, it remindes me to what you mentions as ”tabular form”.

Answer 3

No see in can I do it with dataframe to display all the data in tabular form

Answer 4

Thankyou

Answer 5

No not like that . See I am working on a project in which there is a python which includes python and MySQL code . I had inserted my records. When I want to display it . I display it with fetchall but it returns a list in tuple

Answer 6

I want to convert that list to tabular form

Answer 7

Okay..? So it comes back in a tuple. Do what you want with it after that then. You'll have to code something to display it

Answer 8

That's what I am asking see eg . Looks like this [(1, Ash, usa) ( 2 , Naruto, Japan) ]. So I want to display it in a tabular form. So it will look presentable

Answer 9

I am working on a project for a client

Answer 10

And? What have you tried? Just access each tuple inside the list and print the contents. What. Is. Tabular?

Answer 11

Then do it

Answer 12

if u want to print as a tabular form then use JSON notation to print the data of ur selected query. It is a very good approach in printing data to the console....r else where ever you want...!

Answer 13

Or use NumPy

Answer 14

np.asarray(tuple) returns an array with matrix format when printed

Answer 15

Thankyou