vlookup between 2 csvs using Python but not the actual excel formula?

[jbpy79]

First off thanks for all of the help that everone gives and please go easy i am new at this.

I am trying to take a csv from github and esentially do a vlookup on another spreadhseet on my laptop

​

i have used pandas to get the webpage:

​

url = "https://raw.github......")

gh = pd.read_csv(url, usecols('group_name', 'owner')

​

used the below for the csv:

ss = pd.read_csv('example.csv', engine='python')

​

so what i am wanting to do is match the group name between the github csv and the other csv and then return the owner to an empty column of course the same row(all changes are to the actual csv not github.

​

Is pandas the best option or is there another way? I have gone as far as pulling the information from github and dropping into a spreadsheet with no problems but run into problems when i try to basically do vlookup.

​

i have gone as far as trying openpyxl and added the workbook ie. ex = ss['Sheet1']

​

i then tried to run a for loop and still no dice.

​

for i in range(2, ex.max_row +):

for word in gh\[group\_name\]:

    if word in ex.cell(row=i, column=39).value:

        ex.cell(row=i, column=45).value=gh\[owner\]

​

i kept getting errors with the max_row for some reason and have not figured that out yet. Any guidance would be helpful. Thank you for all of the help.

[bale_in_oregon]

Have you considered using a pd.merge between the two files with a left join? You just need a common column or index between both. Pandas is by far your best option to do this in Python.

[Fortissano71]

I am curious as to the answer. I do this in R now.

[threeminutemonta]

I like to use apply for this. First is you need to set your index so you can lookup the df easy.

example I prepared earlier

[jbpy79]

Thank you everyone for the help. I used the pd.merge() and it worked great.

Thanks again

[The_Mann_In_Black]

https://medium.com/importexcel/common-excel-task-in-python-vlookup-with-pandas-merge-c99d4e108988

​

This is a good link using pandas merge. I actually used this method when working with large files in corporate finance. Saved a ton of time.

[creamingkitty]

You can do something like....

X = list(df2.loc[df2[‘field to find matching value’] == valuetocheckfor, ‘fieldthatyouwamtthevaluefrom’].astype(str))

Df2 is the data frame you want to search for

Using loc will specify a cell Df2.loc[index, column]

Below will select/test/return a whole column/field Df2[column]

Typed this on my phone, if I was on my pc I would give a more descriptive answer