Python Forum
Pandas, How to trigger parallel loop
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pandas, How to trigger parallel loop
#1
Hi,
I have multiple CSV files in the folder, and I need to read each file and some calculation (like getting the first coulmn sum) and concate to result_df. Is there any method in python? to achieve this. Actually to ready and do some calculation, it is taking me 2mins, I need to wait longer time if there are many files.
Reply
#2
Please show your code so far.
Reply
#3
import os
import pandas as pd
 
df_result =pd.DataFrame()
 
directory = os.path.join("D:\\","\PythonCodes\inputmultifiles")
for root,dirs,files in os.walk(directory):
    for file in files:
        f = os.path.join(directory,file)
 
        if f.endswith(".csv"):
           ff=pd.read_csv(f)
           tmp = ff['Name']
           print(tmp)
           df_result= pd.concat([df_result,ff['Name']])
            
df_result = df_result.reset_index(drop=True)      
df_result.columns = ['New_col']
if the file size is large, and it takes time, wait the previous iteration finish. Now I want to do like multiple threading to trigger all iterations at a time and combine the results from each iteration.
Reply
#4
This is really a pandas question, not csv, as pandas reads in the data.
Reply
#5
(Oct-28-2020, 02:21 PM)Larz60+ Wrote: This is really a pandas question, not csv, as pandas reads in the data.

Yes, but more generally I would put it this way: how to trigger multithreading
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  export into excel, how to implement pandas into for-loop deneme2 6 2,357 Sep-01-2022, 05:44 AM
Last Post: deneme2
  parallel loop python caro 4 1,735 Jun-16-2022, 08:46 PM
Last Post: woooee
  How to trigger for loop after while quest 2 1,488 Mar-22-2022, 11:34 PM
Last Post: quest
  Increase the speed of a python loop over a pandas dataframe mcva 0 1,288 Jan-21-2022, 06:24 PM
Last Post: mcva
  For Loop Works Fine But Append For Pandas Doesn't Work knight2000 2 1,928 Dec-18-2021, 02:38 AM
Last Post: knight2000
  for loop in dataframe in pandas Paulman 7 2,672 Dec-02-2021, 12:15 AM
Last Post: bowlofred
  Pandas (Python) in powerBI loop abderrazak_rouchad77 0 1,256 Nov-08-2021, 12:54 AM
Last Post: abderrazak_rouchad77
  loop through python pandas data frame Johnse 4 2,780 Sep-02-2019, 01:45 AM
Last Post: Johnse
  How to trigger python script twice a day SriMekala 1 3,843 Aug-30-2019, 01:31 AM
Last Post: scidam
  Parallel iteration with for loop Josh_Python890 1 2,128 Jul-19-2019, 11:50 PM
Last Post: metulburr

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020