title: How i can insert data from dataframe(in python) to greenplum table?
body: <p><strong>Problem Statement:</strong> </p>
  
  <p>I have multiple csv files. I am cleaning them using python and inserting them to SQL server using <strong>bcp</strong>. Now I want to insert that into Greenplum instead of SQL Server. Please suggest a way to bulk insert into greenplum table directly from python data-frame to GreenPlum table.</p>
  
  <p><strong><em>Solution: (What i can think)</em></strong></p>
  
  <p>Way i can think is CSV-> Dataframe -> Cleainig -> Dataframe -> CSV -> then Use <strong>Gpload</strong> for Bulk load. And integrate it in Shell script for automation. 
  Do anyone has a good solution for it. </p>
  
  <p><strong>Issue in loading data directly from dataframe to gp table:</strong></p>
  
  <p>As gpload ask for the file path. Can i pass a varibale or dataframe to that? Is there any way to bulkload into greenplum ?I dont want to create a csv or txt file from dataframe and then load it to greenplum.</p>