Using excel with python

Question

Hello ladies and gentlemen !
I need some help to work in excel sheets with python.

I have two excel sheets:
One with millions of keywords and some content by their side.
Another with just some keywords, I need to search those keywords in the first file and paste the content from it.

I need some already made script.
If somebody could help, that will be appretiable.
Its for some college project purpose.
Hope someone would help!!!
I am beginner to python

Answer 1

You can complete your project with the help of pandas framework of python.its mainly use to work with data.
try yourself with the help of pandas for some help you can contact me.

Answer 2

Its just a small college project no freelancers to hire.Thanks for your reply, Nice to meet You

Answer 3

agree with Jan Markus
just load two csvs using csv module or pandas module (I’d prefer pandas), run a for loop on the columns you want to compare and write the content once you find a match.
Accessing columns and writing content with both these modules is really simple!
I’d say give it a try rather than asking for a sample code :)

Answer 4

Thanks to all, I will try it first then ask you if further help needed

Answer 5

I have read this article before, but I didn't got what I am actually looking for

Answer 6

It is easier to do it in excel.

Copy the big file into a sheet of the small file.
Use vlookup
Read the docs for vlookup.

Answer 7

Louis , Sir I had tried vlookup, but the data is too large, getting crashed.
I am trying to do it with writing VBA code, copying the big file into a sheet as you said, again chances of getting crashed.,

Answer 8

Anushka Mehta, Thanks mam, I am trying by myself for sure.