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:
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
|
show 2 more comments
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:
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
2
Alistdoesn't have aconcatmethod, but it does have anappendmethod :-)
– 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.listobjects don't have dimensions.
– juanpa.arrivillaga
Nov 12 at 20:25
That's not how you set up instance attributes for aclass.
– Idlehands
Nov 12 at 20:27
|
show 2 more comments
up vote
0
down vote
favorite
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:
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
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:
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
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
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
577
2
Alistdoesn't have aconcatmethod, but it does have anappendmethod :-)
– 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.listobjects don't have dimensions.
– juanpa.arrivillaga
Nov 12 at 20:25
That's not how you set up instance attributes for aclass.
– Idlehands
Nov 12 at 20:27
|
show 2 more comments
2
Alistdoesn't have aconcatmethod, but it does have anappendmethod :-)
– 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.listobjects don't have dimensions.
– juanpa.arrivillaga
Nov 12 at 20:25
That's not how you set up instance attributes for aclass.
– Idlehands
Nov 12 at 20:27
2
2
A
list doesn't have a concat method, but it does have an append method :-)– Rob Bricheno
Nov 12 at 20:16
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
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
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
1
@Tony that doesn't make any sense.
list objects don't have dimensions.– juanpa.arrivillaga
Nov 12 at 20:25
@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
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
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
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
417k34240341
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
A
listdoesn't have aconcatmethod, but it does have anappendmethod :-)– 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.
listobjects 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