For Loop to Concatenate SQL results

up vote
0
down vote

favorite

I am trying to create a function that takes a list, 'teams', runs a SQL query retrieving results for each team using a for loop, returns the results to their respective fields in a dataframe, and then concatenates the data side-by-side. So ideally the results would look something like this:

enter image description here

The code I have below produces an error: "'list' object has no attribute 'concat'". Can someone please advise how I can achieve my desired output?

Thanks!

teams = ['Chicago','Orlando','Miami','New York']



class Team:

    Date = datetime(1900,1,1)

    Pts_Scored = 0



def myfunct(conn, teams):

    curr = conn.cursor()

    pts_scored = 



    for t in teams:

        curr.execute("select date, pts_scored from db.teams where teams ='"+t+"'")

        for i in curr:

            point_hist = Team()

            point_hist.Date = i[1]

            point_hist.Pts_Scored = i[2]

            pts_scored.concat(point_hist)

edited Nov 12 at 20:25

Idlehands

3,9271417

asked Nov 12 at 20:14

Tony

577

2

A list doesn't have a concat method, but it does have an append method :-)
– Rob Bricheno
Nov 12 at 20:16

Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 at 20:18

im not familiar with python. but in sql I can create the query vertical and then use PIVOT to convert it to horizontal format.
– Juan Carlos Oropeza
Nov 12 at 20:21

1

@Tony that doesn't make any sense. list objects don't have dimensions.
– juanpa.arrivillaga
Nov 12 at 20:25

That's not how you set up instance attributes for a class.
– Idlehands
Nov 12 at 20:27

|
show 2 more comments

up vote
0
down vote

favorite

enter image description here

The code I have below produces an error: "'list' object has no attribute 'concat'". Can someone please advise how I can achieve my desired output?

Thanks!

teams = ['Chicago','Orlando','Miami','New York']



class Team:

    Date = datetime(1900,1,1)

    Pts_Scored = 0



def myfunct(conn, teams):

    curr = conn.cursor()

    pts_scored = 



    for t in teams:

        curr.execute("select date, pts_scored from db.teams where teams ='"+t+"'")

        for i in curr:

            point_hist = Team()

            point_hist.Date = i[1]

            point_hist.Pts_Scored = i[2]

            pts_scored.concat(point_hist)

edited Nov 12 at 20:25

Idlehands

3,9271417

asked Nov 12 at 20:14

Tony

577

2

A list doesn't have a concat method, but it does have an append method :-)
– Rob Bricheno
Nov 12 at 20:16

Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 at 20:18

im not familiar with python. but in sql I can create the query vertical and then use PIVOT to convert it to horizontal format.
– Juan Carlos Oropeza
Nov 12 at 20:21

1

@Tony that doesn't make any sense. list objects don't have dimensions.
– juanpa.arrivillaga
Nov 12 at 20:25

That's not how you set up instance attributes for a class.
– Idlehands
Nov 12 at 20:27

|
show 2 more comments

up vote
0
down vote

favorite

enter image description here

The code I have below produces an error: "'list' object has no attribute 'concat'". Can someone please advise how I can achieve my desired output?

Thanks!

teams = ['Chicago','Orlando','Miami','New York']



class Team:

    Date = datetime(1900,1,1)

    Pts_Scored = 0



def myfunct(conn, teams):

    curr = conn.cursor()

    pts_scored = 



    for t in teams:

        curr.execute("select date, pts_scored from db.teams where teams ='"+t+"'")

        for i in curr:

            point_hist = Team()

            point_hist.Date = i[1]

            point_hist.Pts_Scored = i[2]

            pts_scored.concat(point_hist)

edited Nov 12 at 20:25

Idlehands

3,9271417

asked Nov 12 at 20:14

Tony

577

enter image description here

The code I have below produces an error: "'list' object has no attribute 'concat'". Can someone please advise how I can achieve my desired output?

Thanks!

teams = ['Chicago','Orlando','Miami','New York']



class Team:

    Date = datetime(1900,1,1)

    Pts_Scored = 0



def myfunct(conn, teams):

    curr = conn.cursor()

    pts_scored = 



    for t in teams:

        curr.execute("select date, pts_scored from db.teams where teams ='"+t+"'")

        for i in curr:

            point_hist = Team()

            point_hist.Date = i[1]

            point_hist.Pts_Scored = i[2]

            pts_scored.concat(point_hist)

python sql for-loop concatenation

edited Nov 12 at 20:25

Idlehands

3,9271417

asked Nov 12 at 20:14

Tony

577

edited Nov 12 at 20:25

Idlehands

3,9271417

asked Nov 12 at 20:14

Tony

577

edited Nov 12 at 20:25

Idlehands

3,9271417

edited Nov 12 at 20:25

Idlehands

3,9271417

edited Nov 12 at 20:25

Idlehands

3,9271417

asked Nov 12 at 20:14

Tony

577

asked Nov 12 at 20:14

Tony

577

asked Nov 12 at 20:14

Tony

577

2

A list doesn't have a concat method, but it does have an append method :-)
– Rob Bricheno
Nov 12 at 20:16

Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 at 20:18

im not familiar with python. but in sql I can create the query vertical and then use PIVOT to convert it to horizontal format.
– Juan Carlos Oropeza
Nov 12 at 20:21

1

@Tony that doesn't make any sense. list objects don't have dimensions.
– juanpa.arrivillaga
Nov 12 at 20:25

That's not how you set up instance attributes for a class.
– Idlehands
Nov 12 at 20:27

|
show 2 more comments

2

A list doesn't have a concat method, but it does have an append method :-)
– Rob Bricheno
Nov 12 at 20:16

Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 at 20:18

im not familiar with python. but in sql I can create the query vertical and then use PIVOT to convert it to horizontal format.
– Juan Carlos Oropeza
Nov 12 at 20:21

1

@Tony that doesn't make any sense. list objects don't have dimensions.
– juanpa.arrivillaga
Nov 12 at 20:25

That's not how you set up instance attributes for a class.
– Idlehands
Nov 12 at 20:27

A list doesn't have a concat method, but it does have an append method :-)
– Rob Bricheno
Nov 12 at 20:16

Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 at 20:18

im not familiar with python. but in sql I can create the query vertical and then use PIVOT to convert it to horizontal format.
– Juan Carlos Oropeza
Nov 12 at 20:21

@Tony that doesn't make any sense. list objects don't have dimensions.
– juanpa.arrivillaga
Nov 12 at 20:25

That's not how you set up instance attributes for a class.
– Idlehands
Nov 12 at 20:27

|
show 2 more comments

1 Answer
1

active

oldest

votes

up vote
0
down vote

pts_scored should be a dictionary whose keys are the dates. The values should be another dictionary whose keys are team names and values are the scores.

def myfunct(conn, teams):

    curr = conn.cursor()

    pts_scored = {}



    curr.execute("select date, pts_scored, teams from db.teams")

    for i in curr:

        if i['teams'] in teams:

            if i['date'] not in pts_scored:

                pts_scores[i['date']] = {}

            point_hist[i['date']][i['teams'] = i['pts_scored']

You can then use a nested loop to print the table:

# print heading

for team in teams:

    print("Date", team, end='')

print("")

# print results

for date, results in point_hist.items():

    for team in teams

        print(date, results[team], end='')

    print("")

answered Nov 12 at 21:38

Barmar

417k34240341

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53269442%2ffor-loop-to-concatenate-sql-results%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

pts_scored should be a dictionary whose keys are the dates. The values should be another dictionary whose keys are team names and values are the scores.

def myfunct(conn, teams):

    curr = conn.cursor()

    pts_scored = {}



    curr.execute("select date, pts_scored, teams from db.teams")

    for i in curr:

        if i['teams'] in teams:

            if i['date'] not in pts_scored:

                pts_scores[i['date']] = {}

            point_hist[i['date']][i['teams'] = i['pts_scored']

You can then use a nested loop to print the table:

# print heading

for team in teams:

    print("Date", team, end='')

print("")

# print results

for date, results in point_hist.items():

    for team in teams

        print(date, results[team], end='')

    print("")

answered Nov 12 at 21:38

Barmar

417k34240341

add a comment |

up vote
0
down vote

pts_scored should be a dictionary whose keys are the dates. The values should be another dictionary whose keys are team names and values are the scores.

def myfunct(conn, teams):

    curr = conn.cursor()

    pts_scored = {}



    curr.execute("select date, pts_scored, teams from db.teams")

    for i in curr:

        if i['teams'] in teams:

            if i['date'] not in pts_scored:

                pts_scores[i['date']] = {}

            point_hist[i['date']][i['teams'] = i['pts_scored']

You can then use a nested loop to print the table:

# print heading

for team in teams:

    print("Date", team, end='')

print("")

# print results

for date, results in point_hist.items():

    for team in teams

        print(date, results[team], end='')

    print("")

answered Nov 12 at 21:38

Barmar

417k34240341

add a comment |

up vote
0
down vote

pts_scored should be a dictionary whose keys are the dates. The values should be another dictionary whose keys are team names and values are the scores.

def myfunct(conn, teams):

    curr = conn.cursor()

    pts_scored = {}



    curr.execute("select date, pts_scored, teams from db.teams")

    for i in curr:

        if i['teams'] in teams:

            if i['date'] not in pts_scored:

                pts_scores[i['date']] = {}

            point_hist[i['date']][i['teams'] = i['pts_scored']

You can then use a nested loop to print the table:

# print heading

for team in teams:

    print("Date", team, end='')

print("")

# print results

for date, results in point_hist.items():

    for team in teams

        print(date, results[team], end='')

    print("")

answered Nov 12 at 21:38

Barmar

417k34240341

pts_scored should be a dictionary whose keys are the dates. The values should be another dictionary whose keys are team names and values are the scores.

def myfunct(conn, teams):

    curr = conn.cursor()

    pts_scored = {}



    curr.execute("select date, pts_scored, teams from db.teams")

    for i in curr:

        if i['teams'] in teams:

            if i['date'] not in pts_scored:

                pts_scores[i['date']] = {}

            point_hist[i['date']][i['teams'] = i['pts_scored']

You can then use a nested loop to print the table:

# print heading

for team in teams:

    print("Date", team, end='')

print("")

# print results

for date, results in point_hist.items():

    for team in teams

        print(date, results[team], end='')

    print("")

answered Nov 12 at 21:38

Barmar

417k34240341

answered Nov 12 at 21:38

Barmar

417k34240341

answered Nov 12 at 21:38

Barmar

417k34240341

answered Nov 12 at 21:38

Barmar

417k34240341

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Agfdhyk