I have tried different ways to get by using for loop, xlwings,etc but it is taking long time to open or process. Is there any fastest way to read csv files and get cell address of an value?
Asked
Active
Viewed 40 times
0
-
the fastest way is probably to use c/c++ .... `pandas.read_csv` is pretty quick to ... but for this task you will get many wins using c/c++ (ie you can exit early once you find your match) I cant answer if the cost of using C/C++ for this task outweighs any potential benefit – Joran Beasley Feb 09 '22 at 05:17
-
What about loading your csv into a sqlite database and use its indexing feature? – Raymond Kwok Feb 09 '22 at 05:22
-
That iill work how to do that? – Harry Feb 10 '22 at 12:10
-
https://stackoverflow.com/questions/26640129/search-for-string-in-all-pandas-dataframe-columns-and-filter This above link helps me find the answer of this question. – Harry Feb 21 '22 at 07:07