source: trunk/imports/G2pwd_csv.py @ 2133

# -*- coding: utf-8 -*-
########### SVN repository information ###################
# $Date: 2016-01-22 19:05:12 +0000 (Fri, 22 Jan 2016) $
# $Author: toby $
# $Revision: 2133 $
# $URL: trunk/imports/G2pwd_csv.py $
# $Id: G2pwd_csv.py 2133 2016-01-22 19:05:12Z toby $
########### SVN repository information ###################
'''
*Module G2pwd_csv: Read Excel .csv data*
------------------------------------------

Routine to read in powder data from Excel type comma separated variable
column-oriented variable

'''

import sys
import os.path as ospath
import numpy as np
import GSASIIIO as G2IO
import GSASIIpath
GSASIIpath.SetVersionNumber("$Revision: 2133 $")
class csv_ReaderClass(G2IO.ImportPowderData):
    'Routines to import powder data from a .xye file'
    def __init__(self):
        super(self.__class__,self).__init__( # fancy way to self-reference
            extensionlist=('.csv',),
            strictExtension=True,
            formatName = 'comma/tab separated (.csv)',
            longFormatName = 'Worksheet-type .csv powder data file'
            )

    # Validate the contents -- make sure we only have valid lines
    def ContentsValidator(self, filepointer):
        return True # no errors encountered

    def Reader(self,filename,filepointer, ParentFrame=None, **unused):
        'Read a csv file'
        x = []
        y = []
        w = []
        try:
            begin = True
            for i,S in enumerate(filepointer):
                vals = S.replace(',',' ').split()
                if len(vals) < 2 and i > 0:
                    print 'Line '+str(i+1)+' cannot be read:\n\t'+S
                    continue
                try:
                    x.append(float(vals[0]))
                    f = float(vals[1])
                    if f <= 0.0:
                        y.append(0.0)
                        w.append(0.0)
                    elif len(vals) == 3:
                        y.append(float(vals[1]))
                        w.append(1.0/float(vals[2])**2)
                    else:
                        y.append(float(vals[1]))
                        w.append(1.0/float(vals[1]))
                    err = False
                except ValueError:
                    err = True
                    msg = 'Error parsing number in line '+str(i+1)
                except:
                    err = True
                    msg = 'Error in line '+str(i+1)
                if err and i > 0:
                    print msg
                    print S
                    break
            N = len(x)
            self.powderdata = [
                np.array(x), # x-axis values
                np.array(y), # powder pattern intensities
                np.array(w), # 1/sig(intensity)^2 values (weights)
                np.zeros(N), # calc. intensities (zero)
                np.zeros(N), # calc. background (zero)
                np.zeros(N), # obs-calc profiles
                ]
            self.powderentry[0] = filename
            #self.powderentry[1] = pos # bank offset (N/A here)
            self.powderentry[2] = 1 # xye file only has one bank
            self.idstring = ospath.basename(filename)
            # scan comments for temperature
            Temperature = 300
            for S in self.comments:
                if 'Temp' in S.split('=')[0]:
                    try:
                        Temperature = float(S.split('=')[1])
                    except:
                        pass
            self.Sample['Temperature'] = Temperature

            return True
        except Exception as detail:
            self.errors += '\n  '+str(detail)
            print self.formatName+' read error:'+str(detail) # for testing
            import traceback
            traceback.print_exc(file=sys.stdout)
            return False