need to be able to do a lookup on an id in one df and an address in another df to match location to an id











up vote
-2
down vote

favorite
1












This is the df I want to use as the ID to add and the other one is the df with the address in it



enter image description here



the address column into



the first df has multiple rows relating to one address in the other df so I need to do a vlookup to match the ids to addresses






python pandas vlookup







share|improve this question









New contributor




Orla Rafferty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • Probably something in here
    – G. Anderson
    Nov 5 at 17:05










  • I think this just relates to concatenation which I am already familiar with, I need to look up the address data frame to match the ids in the other to each address, I don't know if im even explaining this right
    – Orla Rafferty
    Nov 5 at 17:07










  • It's very unclear what you're asking, from your description it sounds like a join or merge on ID and Address. Otherwise, you could use something like .where() to get the indices and index into the other DF. Generally it's a good idea to post the code you've tried and your expected inputs and outputs (in the question, not as images) to help clarify
    – G. Anderson
    Nov 5 at 17:14










  • I haven't posted on this before which explains it probably. I have posted a photo of the main df.
    – Orla Rafferty
    Nov 5 at 17:16






  • 1




    Apologies, but again I have to say that samples should be posted as code/text in the question, not as images, so that people can run code against your examples. From your description, though, it sounds like you want something like a merge, as in df3=pd.merge(df2, df1, left_on='PracNo', right_on='PRACTICE') or something similar
    – G. Anderson
    Nov 5 at 17:23















up vote
-2
down vote

favorite
1












This is the df I want to use as the ID to add and the other one is the df with the address in it



enter image description here



the address column into



the first df has multiple rows relating to one address in the other df so I need to do a vlookup to match the ids to addresses






python pandas vlookup







share|improve this question









New contributor




Orla Rafferty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




















  • Probably something in here
    – G. Anderson
    Nov 5 at 17:05










  • I think this just relates to concatenation which I am already familiar with, I need to look up the address data frame to match the ids in the other to each address, I don't know if im even explaining this right
    – Orla Rafferty
    Nov 5 at 17:07










  • It's very unclear what you're asking, from your description it sounds like a join or merge on ID and Address. Otherwise, you could use something like .where() to get the indices and index into the other DF. Generally it's a good idea to post the code you've tried and your expected inputs and outputs (in the question, not as images) to help clarify
    – G. Anderson
    Nov 5 at 17:14










  • I haven't posted on this before which explains it probably. I have posted a photo of the main df.
    – Orla Rafferty
    Nov 5 at 17:16






  • 1




    Apologies, but again I have to say that samples should be posted as code/text in the question, not as images, so that people can run code against your examples. From your description, though, it sounds like you want something like a merge, as in df3=pd.merge(df2, df1, left_on='PracNo', right_on='PRACTICE') or something similar
    – G. Anderson
    Nov 5 at 17:23













up vote
-2
down vote

favorite
1









up vote
-2
down vote

favorite
1






1





This is the df I want to use as the ID to add and the other one is the df with the address in it



enter image description here



the address column into



the first df has multiple rows relating to one address in the other df so I need to do a vlookup to match the ids to addresses






python pandas vlookup







share|improve this question









New contributor




Orla Rafferty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











This is the df I want to use as the ID to add and the other one is the df with the address in it



enter image description here



the address column into



the first df has multiple rows relating to one address in the other df so I need to do a vlookup to match the ids to addresses






python pandas vlookup




python pandas vlookup






share|improve this question









New contributor




Orla Rafferty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Orla Rafferty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited Nov 5 at 17:15









Derlin

6,08121632




6,08121632






New contributor




Orla Rafferty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked Nov 5 at 17:00









Orla Rafferty

11




11




New contributor




Orla Rafferty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Orla Rafferty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Orla Rafferty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












  • Probably something in here
    – G. Anderson
    Nov 5 at 17:05










  • I think this just relates to concatenation which I am already familiar with, I need to look up the address data frame to match the ids in the other to each address, I don't know if im even explaining this right
    – Orla Rafferty
    Nov 5 at 17:07










  • It's very unclear what you're asking, from your description it sounds like a join or merge on ID and Address. Otherwise, you could use something like .where() to get the indices and index into the other DF. Generally it's a good idea to post the code you've tried and your expected inputs and outputs (in the question, not as images) to help clarify
    – G. Anderson
    Nov 5 at 17:14










  • I haven't posted on this before which explains it probably. I have posted a photo of the main df.
    – Orla Rafferty
    Nov 5 at 17:16






  • 1




    Apologies, but again I have to say that samples should be posted as code/text in the question, not as images, so that people can run code against your examples. From your description, though, it sounds like you want something like a merge, as in df3=pd.merge(df2, df1, left_on='PracNo', right_on='PRACTICE') or something similar
    – G. Anderson
    Nov 5 at 17:23


















  • Probably something in here
    – G. Anderson
    Nov 5 at 17:05










  • I think this just relates to concatenation which I am already familiar with, I need to look up the address data frame to match the ids in the other to each address, I don't know if im even explaining this right
    – Orla Rafferty
    Nov 5 at 17:07










  • It's very unclear what you're asking, from your description it sounds like a join or merge on ID and Address. Otherwise, you could use something like .where() to get the indices and index into the other DF. Generally it's a good idea to post the code you've tried and your expected inputs and outputs (in the question, not as images) to help clarify
    – G. Anderson
    Nov 5 at 17:14










  • I haven't posted on this before which explains it probably. I have posted a photo of the main df.
    – Orla Rafferty
    Nov 5 at 17:16






  • 1




    Apologies, but again I have to say that samples should be posted as code/text in the question, not as images, so that people can run code against your examples. From your description, though, it sounds like you want something like a merge, as in df3=pd.merge(df2, df1, left_on='PracNo', right_on='PRACTICE') or something similar
    – G. Anderson
    Nov 5 at 17:23
















Probably something in here
– G. Anderson
Nov 5 at 17:05




Probably something in here
– G. Anderson
Nov 5 at 17:05












I think this just relates to concatenation which I am already familiar with, I need to look up the address data frame to match the ids in the other to each address, I don't know if im even explaining this right
– Orla Rafferty
Nov 5 at 17:07




I think this just relates to concatenation which I am already familiar with, I need to look up the address data frame to match the ids in the other to each address, I don't know if im even explaining this right
– Orla Rafferty
Nov 5 at 17:07












It's very unclear what you're asking, from your description it sounds like a join or merge on ID and Address. Otherwise, you could use something like .where() to get the indices and index into the other DF. Generally it's a good idea to post the code you've tried and your expected inputs and outputs (in the question, not as images) to help clarify
– G. Anderson
Nov 5 at 17:14




It's very unclear what you're asking, from your description it sounds like a join or merge on ID and Address. Otherwise, you could use something like .where() to get the indices and index into the other DF. Generally it's a good idea to post the code you've tried and your expected inputs and outputs (in the question, not as images) to help clarify
– G. Anderson
Nov 5 at 17:14












I haven't posted on this before which explains it probably. I have posted a photo of the main df.
– Orla Rafferty
Nov 5 at 17:16




I haven't posted on this before which explains it probably. I have posted a photo of the main df.
– Orla Rafferty
Nov 5 at 17:16




1




1




Apologies, but again I have to say that samples should be posted as code/text in the question, not as images, so that people can run code against your examples. From your description, though, it sounds like you want something like a merge, as in df3=pd.merge(df2, df1, left_on='PracNo', right_on='PRACTICE') or something similar
– G. Anderson
Nov 5 at 17:23




Apologies, but again I have to say that samples should be posted as code/text in the question, not as images, so that people can run code against your examples. From your description, though, it sounds like you want something like a merge, as in df3=pd.merge(df2, df1, left_on='PracNo', right_on='PRACTICE') or something similar
– G. Anderson
Nov 5 at 17:23

















active

oldest

votes











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',
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
});


}
});






Orla Rafferty is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53158907%2fneed-to-be-able-to-do-a-lookup-on-an-id-in-one-df-and-an-address-in-another-df-t%23new-answer', 'question_page');
}
);

Post as a guest























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes








Orla Rafferty is a new contributor. Be nice, and check out our Code of Conduct.










 

draft saved


draft discarded


















Orla Rafferty is a new contributor. Be nice, and check out our Code of Conduct.













Orla Rafferty is a new contributor. Be nice, and check out our Code of Conduct.












Orla Rafferty is a new contributor. Be nice, and check out our Code of Conduct.















 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53158907%2fneed-to-be-able-to-do-a-lookup-on-an-id-in-one-df-and-an-address-in-another-df-t%23new-answer', 'question_page');
}
);

Post as a guest






































































-

這個網誌中的熱門文章

Hercules Kyvelos

圖片
Hercules Kyvelos Statistics Real name Hercules Kyvelos Nickname(s) The God Weight(s) Middleweight Light Middleweight Welterweight Height 5 ft 10 in (180 cm) Reach 72 in (183 cm) Nationality Canadian Born ( 1975-02-25 ) February 25, 1975 (age 43) Montreal, Quebec Stance Orthodox Boxing record Total fights 27 Wins 24 Wins by KO 12 Losses 3 Draws 0 No contests 0 Hercules Kyvelos Medal record Men's Boxing Representing   Canada Pan American Games 1995 Mar del Plata Welterweight Hercules Kyvelos (born February 25, 1975) is a Greek-Canadian boxer in the Welterweight division and is the former Canadian Welterweight Champion. [1] He fought at the 1996 Summer Olympics in Atlanta, Georgia. Contents 1 Early life 2 Amateur career 3 Pro career 3.1 WBO Welterweight Championship 3.2 Personal life 4 References 5 External links Early life Hercules was born in
閱讀完整內容

Tangent Lines Diagram Along Smooth Curve

圖片
7 1 I am trying to replicate a diagram and have a minimal example. I don't know how to add additional tangents between the specified points and preserve smoothness. documentclass{article} usepackage{tikz} usetikzlibrary{calc,intersections} begin{document} begin{tikzpicture} % Axes draw [->, name path=x] (-1,0) -- (11,0) node [right] {$x$}; draw [->] (0,-1) -- (0,6) node [above] {$y$}; % Origin node at (0,0) [below left] {$0$}; % Points coordinate (start) at (1,-0.8); coordinate (c1) at (3,3); coordinate (c2) at (5.5,1.5); coordinate (c3) at (8,4); coordinate (end) at (10.5,-0.8); % show the points foreach n in {start,c1,c2,c3,end} fill [black] (n) circle (2pt) node [below] {}; % join the coordinates draw [thick,name path=curve] (start) to[out=70,in=180] (c1) to[out=0,in=180]
閱讀完整內容

Yusuf al-Mu'taman ibn Hud

圖片
Main article: Taifa of Zaragoza Al-Mu'taman Ruler of Zaragoza Reign 1081–1085 Predecessor Ahmad al-Muqtadir Successor Al-Mustain II Born Zaragoza Died 1085 Full name Yusuf ibn Ahmad al-Mu'taman ibn Hūd House Banu Hud Yusuf ibn Ahmad al-Mu'taman ibn Hūd (Arabic: المؤتمن بالله يوسف إبن أحمد إبن هود ‎, al-Mutaman bi l-Lah , died c. 1085) was the third king of the Banu Hud dynasty who ruled over the Taifa of Zaragoza from 1081 to 1085. Yusuf al-Mutaman reigned during the height of power of Muslim Zaragoza , following the thriving period of his father Ahmad al-Muqtadir. He continued his father's efforts and created around him a court of intellectuals, living in the beautiful palace of Aljafería, nicknamed as "the palace of joy". Al-Mu'taman was also a scholarly king and a patron of science, philosophy and arts. As an example of a wise king, he knew astrology, philosophy, and especially mathematics, a discipline in which
閱讀完整內容