+ 1
Using excel with python
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
8 Answers
+ 4
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.
+ 2
Its just a small college project no freelancers to hire.Thanks for your reply, Nice to meet You
+ 2
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 :)
+ 1
Thanks to all, I will try it first then ask you if further help needed
+ 1
I have read this article before, but I didn't got what I am actually looking for
+ 1
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.
+ 1
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.,
0
Anushka Mehta, Thanks mam, I am trying by myself for sure.