For Loop to Concatenate SQL results
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
|
show 2 more comments
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
2
Alist
doesn't have aconcat
method, but it does have anappend
method :-)
– Rob Bricheno
Nov 12 '18 at 20:16
Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 '18 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 '18 at 20:21
1
@Tony that doesn't make any sense.list
objects don't have dimensions.
– juanpa.arrivillaga
Nov 12 '18 at 20:25
That's not how you set up instance attributes for aclass
.
– Idlehands
Nov 12 '18 at 20:27
|
show 2 more comments
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
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 '18 at 20:25
Idlehands
4,2011517
4,2011517
asked Nov 12 '18 at 20:14
TonyTony
577
577
2
Alist
doesn't have aconcat
method, but it does have anappend
method :-)
– Rob Bricheno
Nov 12 '18 at 20:16
Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 '18 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 '18 at 20:21
1
@Tony that doesn't make any sense.list
objects don't have dimensions.
– juanpa.arrivillaga
Nov 12 '18 at 20:25
That's not how you set up instance attributes for aclass
.
– Idlehands
Nov 12 '18 at 20:27
|
show 2 more comments
2
Alist
doesn't have aconcat
method, but it does have anappend
method :-)
– Rob Bricheno
Nov 12 '18 at 20:16
Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 '18 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 '18 at 20:21
1
@Tony that doesn't make any sense.list
objects don't have dimensions.
– juanpa.arrivillaga
Nov 12 '18 at 20:25
That's not how you set up instance attributes for aclass
.
– Idlehands
Nov 12 '18 at 20:27
2
2
A
list
doesn't have a concat
method, but it does have an append
method :-)– Rob Bricheno
Nov 12 '18 at 20:16
A
list
doesn't have a concat
method, but it does have an append
method :-)– Rob Bricheno
Nov 12 '18 at 20:16
Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 '18 at 20:18
Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 '18 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 '18 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 '18 at 20:21
1
1
@Tony that doesn't make any sense.
list
objects don't have dimensions.– juanpa.arrivillaga
Nov 12 '18 at 20:25
@Tony that doesn't make any sense.
list
objects don't have dimensions.– juanpa.arrivillaga
Nov 12 '18 at 20:25
That's not how you set up instance attributes for a
class
.– Idlehands
Nov 12 '18 at 20:27
That's not how you set up instance attributes for a
class
.– Idlehands
Nov 12 '18 at 20:27
|
show 2 more comments
1 Answer
1
active
oldest
votes
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("")
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
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("")
add a comment |
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("")
add a comment |
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("")
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 '18 at 21:38
BarmarBarmar
420k35244344
420k35244344
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
list
doesn't have aconcat
method, but it does have anappend
method :-)– Rob Bricheno
Nov 12 '18 at 20:16
Agree but to my knowledge the append would merge the results vertically instead of horizontally?
– Tony
Nov 12 '18 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 '18 at 20:21
1
@Tony that doesn't make any sense.
list
objects don't have dimensions.– juanpa.arrivillaga
Nov 12 '18 at 20:25
That's not how you set up instance attributes for a
class
.– Idlehands
Nov 12 '18 at 20:27