title: ProgrammingError: (psycopg2.ProgrammingError) can't adapt type 'numpy.ndarray'
body: <p>I am creating a python script using pandas to read through a file which has multiple row values. </p>
  
  <p>Once read, I need to build an array of these values and then assign it to a dataframe row value. </p>
  
  <p>The code I have used is </p>
  
  <pre><code>import re
  import numpy as np
  import pandas as pd
  master_data = pd.DataFrame()
  temp_df = pd.DataFrame()
  new_df = pd.DataFrame()
  
  for f in data:
  
  
  ##Reading the file in pandas which is in excel format 
  #
  file_df = pd.read_excel(f)
  
  
  filename = file_df['Unnamed: 1'][2]
  
  
  ##Skipping first 24 rows to get the required reading values
  column_names = ['start_time','xxx_value']
  data_df = pd.read_excel(f, names=column_names, skiprows=25)
  
  
  array =np.array([])
  
     for i in data_df.iterrows():
         array = np.append(array,i[1][1])
  
  
     temp_df['xxx_value'] = [array]
     temp_df['Filename'] = filename
     temp_df['sub_id']=       
     temp_df['Filename'].str.split('_',1).str[1].str.strip() 
     temp_df['sen_site']=    
     temp_df['Filename'].str.split('_',1).str[0].str.strip()
     temp_df['sampling_interval'] = 15
     temp_df['start_time'] = data_df['start_time'][2]
  
  
     new_df= new_df.append(xxx_df)
  
     new_df.index = new_df.index + 1
     new_df=new_df.sort_index()
     new_df.index.name='record_id'
  
    new_df = new_df.drop("Filename",1)    ##dropping the Filename as it          
    is not needed to be loaded in postgresql
  
   ##Rearrange to postgresql format
   column_new_df = new_df.columns.tolist()
   column_new_df.
   insert(4,column_new_df.pop(column_new_df.index('xxx_value')))
   new_df = new_df.reindex(columns = column_new_df)
  
   print(new_df)
  </code></pre>
  
  <p>This code is not working when I try to insert the array data into Postgresql. </p>
  
  <p>It gives me an error stating: </p>
  
  <blockquote>
    <p>ProgrammingError: (psycopg2.ProgrammingError) can't adapt type
    'numpy.ndarray'</p>
  </blockquote>