How to display data as array format using python

Question

def index(request):
    conn = MySQLdb.connect(host="localhost", user="user", passwd="pwd", db="highchart_with_django")
    cursor = conn.cursor()
    cursor.execute("SELECT categories,tokyo,london,new_york,berlin FROM basic_line_chart")
    row = cursor.fetchone()
    while row is not None:
       print row
       row = cursor.fetchone()
    return render(request, "linechart.html")

It's giving output like below:

('Sep', Decimal('7.00'), Decimal('3.90'), Decimal('-0.20'), Decimal('-0.90'))
('Oct', Decimal('6.90'), Decimal('4.20'), Decimal('0.80'), Decimal('0.60'))

expecting output:

 ["Sep", "7.00", "3.90", "-0.20", "-0.90"],["Oct", "6.90", "4.20", "0.80", "0.60"]

How can i achieve this. please help me with this.

gallen · Accepted Answer · 2017-02-17 05:23:58Z

2

According to this link http://mysql-python.sourceforge.net/MySQLdb.html fetchone() returns a tuple.

To convert that to a list, simply cast it.

row = list(cursor.fetchone())

You can then iterate the list to get them in the proper format you are seeking.

answered Feb 17, 2017 at 5:23

gallen

1,2921 gold badge19 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex Taylor · Accepted Answer · 2017-02-17 05:21:46Z

1

Blindly converting everything to strings (because you haven't been specific):

def index(request):
    conn = MySQLdb.connect(host="localhost", user="user", passwd="pwd", db="highchart_with_django")
    cursor = conn.cursor()
    cursor.execute("SELECT categories,tokyo,london,new_york,berlin FROM basic_line_chart")
    rows = [[str(field) for field in row] for row in cursor]
    for row in rows:
        print(row)
    return render(request, "linechart.html")

I'm not sure this solves your problem. Do you want all the Decimal converted to strings? Some kind of floating point number is probably more useful for charting.

answered Feb 17, 2017 at 5:21

Alex Taylor

8,9334 gold badges29 silver badges44 bronze badges

2 Comments

Venkatesh Panabaka Over a year ago

each row seperate with comma. how to do that?

Alex Taylor Over a year ago

Try print(rows). Is that what you want?

brianz · Accepted Answer · 2017-02-17 05:25:34Z

1

Your question isn't 100% clear but if you're really just trying to get a list of strings:

>>> for row in cursor.fetchall():
...     print [str(col) for col in row]
...
['Sep', '7.00', '3.90', '-0.20', '-0.90']
['Oct', '6.90', '4.20', '0.80', '0.60']

answered Feb 17, 2017 at 5:25

brianz

7,5086 gold badges40 silver badges44 bronze badges

Comments

Piyush S. Wanare · Accepted Answer · 2017-02-17 06:06:31Z

1

Try this:-

def index(request):
    conn = MySQLdb.connect(host="localhost", user="user", passwd="pwd", db="highchart_with_django")
    cursor = conn.cursor()
    cursor.execute("SELECT categories,tokyo,london,new_york,berlin FROM basic_line_chart")
    row = cursor.fetchone()
    while row is not None:
       print row
       row = list(cursor.fetchone())
    return render(request, "linechart.html")

answered Feb 17, 2017 at 6:06

Piyush S. Wanare

4,9836 gold badges41 silver badges55 bronze badges

Comments

Piyush S. Wanare · Accepted Answer · 2017-02-17 06:10:49Z

1

please try

row = cursor.dictfetchall() #which gives dict

row = cursor.fetchall() #gives a list.

Output :-

["Sep", "7.00", "3.90", "-0.20", "-0.90"],["Oct", "6.90", "4.20", "0.80", "0.60"]

edited Feb 17, 2017 at 6:10

Piyush S. Wanare

4,9836 gold badges41 silver badges55 bronze badges

answered Feb 17, 2017 at 5:50

Hilar AK

1,68515 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to display data as array format using python

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related