Appending row to a dataframe makes the column labels to the index
0
I am somehow stuck here at the moment, I have an (in the beginning empty) dataframe df_ben_Boxen, to which I want to add the rows of df_Box_Code_Inhalt if they are containing the same Artikelnr as the row in df_Stueckliste
At the moment, it writes the index with the column-labels, which isn't what I want.
import pandas as pd
df_Box_Code_Inhalt=pd.read_excel("Box_Code_Inhalt.xlsx")
df_ben_Boxen=pd.DataFrame()
def Lade_Zuordnungen(df_ben_Boxen, df_Stueckliste):
for index, row in df_Stueckliste.iterrows():
for index2, row in df_Box_Code_Inhalt.iterrows():
if df_Stueckliste.at[index,"Artikelnr"]==df_Box_Code_Inhalt.at[index2,"Artikelnr"]:
df_ben_Boxen=pd.concat([df_ben_Boxen,df_Box_Code_Inhalt.loc[index2]],axis=1)
return df_ben_Boxen
Would be nice if some1 could tell me a fix, i am new to python and can't figure it out atm.
Contents of the original dataframe compared to the changed indexing
python pandas dataframe append concat
edited Nov 28 '18 at 0:30
Josh21
779
asked Nov 28 '18 at 0:26
Terminator93 RA1DTerminator93 RA1D
42
add a comment |
0
I am somehow stuck here at the moment, I have an (in the beginning empty) dataframe df_ben_Boxen, to which I want to add the rows of df_Box_Code_Inhalt if they are containing the same Artikelnr as the row in df_Stueckliste
At the moment, it writes the index with the column-labels, which isn't what I want.
import pandas as pd
df_Box_Code_Inhalt=pd.read_excel("Box_Code_Inhalt.xlsx")
df_ben_Boxen=pd.DataFrame()
def Lade_Zuordnungen(df_ben_Boxen, df_Stueckliste):
for index, row in df_Stueckliste.iterrows():
for index2, row in df_Box_Code_Inhalt.iterrows():
if df_Stueckliste.at[index,"Artikelnr"]==df_Box_Code_Inhalt.at[index2,"Artikelnr"]:
df_ben_Boxen=pd.concat([df_ben_Boxen,df_Box_Code_Inhalt.loc[index2]],axis=1)
return df_ben_Boxen
Would be nice if some1 could tell me a fix, i am new to python and can't figure it out atm.
Contents of the original dataframe compared to the changed indexing
python pandas dataframe append concat
edited Nov 28 '18 at 0:30
Josh21
779
asked Nov 28 '18 at 0:26
Terminator93 RA1DTerminator93 RA1D
42
2
Welcome to SO, people will be able to help you better if you provide mcve. You can print df_ben_Boxen.head() and df_Stueckliste.head() and expected output
– Vaishali
Nov 28 '18 at 0:30
Now i tried to accept it this way and transpose the datafield by writingdf_Box_Code_Inhalt.Tbut it doesnt switch rows and columns.
– Terminator93 RA1D
Nov 28 '18 at 9:08
add a comment |
0
0
0
1
I am somehow stuck here at the moment, I have an (in the beginning empty) dataframe df_ben_Boxen, to which I want to add the rows of df_Box_Code_Inhalt if they are containing the same Artikelnr as the row in df_Stueckliste
At the moment, it writes the index with the column-labels, which isn't what I want.
import pandas as pd
df_Box_Code_Inhalt=pd.read_excel("Box_Code_Inhalt.xlsx")
df_ben_Boxen=pd.DataFrame()
def Lade_Zuordnungen(df_ben_Boxen, df_Stueckliste):
for index, row in df_Stueckliste.iterrows():
for index2, row in df_Box_Code_Inhalt.iterrows():
if df_Stueckliste.at[index,"Artikelnr"]==df_Box_Code_Inhalt.at[index2,"Artikelnr"]:
df_ben_Boxen=pd.concat([df_ben_Boxen,df_Box_Code_Inhalt.loc[index2]],axis=1)
return df_ben_Boxen
Would be nice if some1 could tell me a fix, i am new to python and can't figure it out atm.
Contents of the original dataframe compared to the changed indexing
python pandas dataframe append concat
edited Nov 28 '18 at 0:30
Josh21
779
asked Nov 28 '18 at 0:26
Terminator93 RA1DTerminator93 RA1D
42
I am somehow stuck here at the moment, I have an (in the beginning empty) dataframe df_ben_Boxen, to which I want to add the rows of df_Box_Code_Inhalt if they are containing the same Artikelnr as the row in df_Stueckliste
At the moment, it writes the index with the column-labels, which isn't what I want.
import pandas as pd
df_Box_Code_Inhalt=pd.read_excel("Box_Code_Inhalt.xlsx")
df_ben_Boxen=pd.DataFrame()
def Lade_Zuordnungen(df_ben_Boxen, df_Stueckliste):
for index, row in df_Stueckliste.iterrows():
for index2, row in df_Box_Code_Inhalt.iterrows():
if df_Stueckliste.at[index,"Artikelnr"]==df_Box_Code_Inhalt.at[index2,"Artikelnr"]:
df_ben_Boxen=pd.concat([df_ben_Boxen,df_Box_Code_Inhalt.loc[index2]],axis=1)
return df_ben_Boxen
Would be nice if some1 could tell me a fix, i am new to python and can't figure it out atm.
Contents of the original dataframe compared to the changed indexing
python pandas dataframe append concat
python pandas dataframe append concat
edited Nov 28 '18 at 0:30
Josh21
779
asked Nov 28 '18 at 0:26
Terminator93 RA1DTerminator93 RA1D
42
edited Nov 28 '18 at 0:30
Josh21
779
asked Nov 28 '18 at 0:26
Terminator93 RA1DTerminator93 RA1D
42
edited Nov 28 '18 at 0:30
Josh21
779
edited Nov 28 '18 at 0:30
Josh21
779
edited Nov 28 '18 at 0:30
Josh21
779
779
asked Nov 28 '18 at 0:26
Terminator93 RA1DTerminator93 RA1D
42
asked Nov 28 '18 at 0:26
Terminator93 RA1DTerminator93 RA1D
42
asked Nov 28 '18 at 0:26
Terminator93 RA1DTerminator93 RA1D
42
42
2
Welcome to SO, people will be able to help you better if you provide mcve. You can print df_ben_Boxen.head() and df_Stueckliste.head() and expected output
– Vaishali
Nov 28 '18 at 0:30
Now i tried to accept it this way and transpose the datafield by writingdf_Box_Code_Inhalt.Tbut it doesnt switch rows and columns.
– Terminator93 RA1D
Nov 28 '18 at 9:08
add a comment |
2
Welcome to SO, people will be able to help you better if you provide mcve. You can print df_ben_Boxen.head() and df_Stueckliste.head() and expected output
– Vaishali
Nov 28 '18 at 0:30
Now i tried to accept it this way and transpose the datafield by writingdf_Box_Code_Inhalt.Tbut it doesnt switch rows and columns.
– Terminator93 RA1D
Nov 28 '18 at 9:08
2
2
Welcome to SO, people will be able to help you better if you provide mcve. You can print df_ben_Boxen.head() and df_Stueckliste.head() and expected output
– Vaishali
Nov 28 '18 at 0:30
Welcome to SO, people will be able to help you better if you provide mcve. You can print df_ben_Boxen.head() and df_Stueckliste.head() and expected output
– Vaishali
Nov 28 '18 at 0:30
Now i tried to accept it this way and transpose the datafield by writing
df_Box_Code_Inhalt.Tbut it doesnt switch rows and columns.– Terminator93 RA1D
Nov 28 '18 at 9:08
Now i tried to accept it this way and transpose the datafield by writing
df_Box_Code_Inhalt.Tbut it doesnt switch rows and columns.– Terminator93 RA1D
Nov 28 '18 at 9:08
add a comment |
1 Answer
1
active
oldest
votes
0
I got my problem solved like this:
import pandas as pd
df_Box_Code_Inhalt=pd.read_excel("Box_Code_Inhalt.xlsx")
def Lade_Zuordnungen(df_ben_Boxen, df_Stueckliste):
df_ben_Boxen=pd.read_excel("Box_Code_Inhalt.xlsx")
df_ben_Boxen.drop(df_ben_Boxen.index, inplace=True)
for index, row in df_Stueckliste.iterrows():
for index2, row in df_Box_Code_Inhalt.iterrows():
if df_Stueckliste.at[index,"Artikelnr"]==df_Box_Code_Inhalt.at[index2,"Artikelnr"]:
data=list(df_Box_Code_Inhalt.iloc[index2])
df_ben_Boxen.loc[len(df_ben_Boxen)]=data
return df_ben_Boxen
answered Nov 28 '18 at 9:46
Terminator93 RA1DTerminator93 RA1D
42
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');
});
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%2f53510309%2fappending-row-to-a-dataframe-makes-the-column-labels-to-the-index%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
0
I got my problem solved like this:
import pandas as pd
df_Box_Code_Inhalt=pd.read_excel("Box_Code_Inhalt.xlsx")
def Lade_Zuordnungen(df_ben_Boxen, df_Stueckliste):
df_ben_Boxen=pd.read_excel("Box_Code_Inhalt.xlsx")
df_ben_Boxen.drop(df_ben_Boxen.index, inplace=True)
for index, row in df_Stueckliste.iterrows():
for index2, row in df_Box_Code_Inhalt.iterrows():
if df_Stueckliste.at[index,"Artikelnr"]==df_Box_Code_Inhalt.at[index2,"Artikelnr"]:
data=list(df_Box_Code_Inhalt.iloc[index2])
df_ben_Boxen.loc[len(df_ben_Boxen)]=data
return df_ben_Boxen
answered Nov 28 '18 at 9:46
Terminator93 RA1DTerminator93 RA1D
42
add a comment |
0
I got my problem solved like this:
import pandas as pd
df_Box_Code_Inhalt=pd.read_excel("Box_Code_Inhalt.xlsx")
def Lade_Zuordnungen(df_ben_Boxen, df_Stueckliste):
df_ben_Boxen=pd.read_excel("Box_Code_Inhalt.xlsx")
df_ben_Boxen.drop(df_ben_Boxen.index, inplace=True)
for index, row in df_Stueckliste.iterrows():
for index2, row in df_Box_Code_Inhalt.iterrows():
if df_Stueckliste.at[index,"Artikelnr"]==df_Box_Code_Inhalt.at[index2,"Artikelnr"]:
data=list(df_Box_Code_Inhalt.iloc[index2])
df_ben_Boxen.loc[len(df_ben_Boxen)]=data
return df_ben_Boxen
answered Nov 28 '18 at 9:46
Terminator93 RA1DTerminator93 RA1D
42
add a comment |
0
0
0
I got my problem solved like this:
import pandas as pd
df_Box_Code_Inhalt=pd.read_excel("Box_Code_Inhalt.xlsx")
def Lade_Zuordnungen(df_ben_Boxen, df_Stueckliste):
df_ben_Boxen=pd.read_excel("Box_Code_Inhalt.xlsx")
df_ben_Boxen.drop(df_ben_Boxen.index, inplace=True)
for index, row in df_Stueckliste.iterrows():
for index2, row in df_Box_Code_Inhalt.iterrows():
if df_Stueckliste.at[index,"Artikelnr"]==df_Box_Code_Inhalt.at[index2,"Artikelnr"]:
data=list(df_Box_Code_Inhalt.iloc[index2])
df_ben_Boxen.loc[len(df_ben_Boxen)]=data
return df_ben_Boxen
answered Nov 28 '18 at 9:46
Terminator93 RA1DTerminator93 RA1D
42
I got my problem solved like this:
import pandas as pd
df_Box_Code_Inhalt=pd.read_excel("Box_Code_Inhalt.xlsx")
def Lade_Zuordnungen(df_ben_Boxen, df_Stueckliste):
df_ben_Boxen=pd.read_excel("Box_Code_Inhalt.xlsx")
df_ben_Boxen.drop(df_ben_Boxen.index, inplace=True)
for index, row in df_Stueckliste.iterrows():
for index2, row in df_Box_Code_Inhalt.iterrows():
if df_Stueckliste.at[index,"Artikelnr"]==df_Box_Code_Inhalt.at[index2,"Artikelnr"]:
data=list(df_Box_Code_Inhalt.iloc[index2])
df_ben_Boxen.loc[len(df_ben_Boxen)]=data
return df_ben_Boxen
answered Nov 28 '18 at 9:46
Terminator93 RA1DTerminator93 RA1D
42
answered Nov 28 '18 at 9:46
Terminator93 RA1DTerminator93 RA1D
42
answered Nov 28 '18 at 9:46
Terminator93 RA1DTerminator93 RA1D
42
answered Nov 28 '18 at 9:46
Terminator93 RA1DTerminator93 RA1D
42
42
add a comment |
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.
draft saved
draft discarded
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%2f53510309%2fappending-row-to-a-dataframe-makes-the-column-labels-to-the-index%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
Welcome to SO, people will be able to help you better if you provide mcve. You can print df_ben_Boxen.head() and df_Stueckliste.head() and expected output
– Vaishali
Nov 28 '18 at 0:30
Now i tried to accept it this way and transpose the datafield by writing
df_Box_Code_Inhalt.Tbut it doesnt switch rows and columns.– Terminator93 RA1D
Nov 28 '18 at 9:08