DataRange::GetData

GetData

1 Description
2 Syntax
3 Parameters
4 Return
5 Examples
6 Remark
7 See Also
8 header to Include

Description

Get the data from indexed subrange get data from all subrange if nIndex is negative.

It extracts data from the object.

It extracts matrix data from DataRange.

Syntax

BOOL GetData( vectorbase * pData, int nIndex, DWORD dwRules2 = 0 )

int GetData( DWORD dwRules, int nIndex, DWORD * pouidAux, string * pstrDescriptive, vectorbase * pv, vector * pvIndep = NULL, matrix * pmMultiIndep = NULL, vector<string> * pstrFactors = NULL, vector * pvWeights = NULL, vector * pvErrDep = NULL, vector * pvErrIndep = NULL, Worksheet * pwksData = NULL, vector * pvYIndep = NULL, vector<int> * pvintRowsInSource = NULL, STGETDATAOUTPUTINFO * pstOutInfo = NULL, DWORD dwRules2 = 0 )

int GetData( DWORD dwRules, int nIndex, vector<int> & vIndicesIn, vector & vMainOut, vector & vIndepOut, vector & vYIndepOut = NULL )

int GetData( matrixbase & m, DWORD dwRules = 0, int index = 0, DWORD dwRules2 = 0 )

int GetData(STDRGETDATAARGS & gdInfoOut, STGETDATAOUTPUTINFO * pstOutInfo = NULL)

Parameters

pData: [output] it receives the data in range
nIndex: [input] the index of data

dwRules: [input]the optional bits from the DRR_ enumeration.
nIndex: [input]the index of the data. DataRange can reference multiple sets of data. Index starts from 0. See AddInput for an example.
pouidAux: [output] if supplied, it receives the dataplot UID stored in the DataRange object.
pstrDescriptive: [input]not used
pv: [output]it receives the main data values.
pvIndep: [output]it receives the X-independent data if DRR_GET_DEPENDENT or DRR_GET_Z_DEPENDENT rules bits are passed in.
pmMultiIndep: [output]it receives the (potentially) multiple X-independent data if DRR_GET_DEPENDENT and DRR_ONE_DEP_MULTIINDEP bits are passed in; (appropriate for Multiple Regression).
pstrFactors: [output]it receives the values of factors for each factor data that correspond to the values; returned into pv. The size of the returned vector is equal to the total number of factors.
pvWeights: [output]it receives the weight values
pvErrDep: [output]it receives the dependent error values
pvErrIndep: [output]it receives the independent error values
pwksData: [output] it is initialized to the Worksheet object to which the main data belongs.
pvYIndep: [output] it receives the Y-independent data. Used only if DRR_GET_Z_DEPENDENT rules bit is supplied.

pvintRowsInSource: [output] it receives the row indices in the source
pstOutInfo: [output]a pointer which points to output structure STGETDATAOUTPUTINFO. Keep it as NULL if the output is not necessary. STGETDATAOUTPUTINFO is defined in OC_types.h
dwRules2: bits from the DRR2_ enumeration.

dwRules: [input]the rules for extracting data from DRR_ enumeration.
nIndex: [input]the data index
vIndicesIn: [input]the row indices that need to be extracted
vMainOut: [output]the main data
vIndepOut: [output]the X independent data
vYIndepOut: [output]the Y-independent data (used only if DRR_GET_Z_DEPENDENT supplied in dwRules, which means XYZ data)

m: [output]the matrixbase object which will receive the matrix data.
dwRules: [input]not used, must be 0.
index: [input]data index in case DataRange refers to multiple matrices.

gdInfoOut: [modify]a STDRGETDATAARGS structure which includes all parameters except output structure STGETDATAOUTPUTINFO. STDRGETDATAARGS is defined in Range.h:

struct STDRGETDATAARGS 
{
        int nIndex;
        DWORD dwRules;
        DWORD dwRules2;
        DWORD *pouidAux;
        string *pstrDescriptive;
        vectorbase *pv;
        vector *pvIndep;
        matrix *pmMultiIndep;
        vector<string> *pstrFactors;
        vector *pvWeights;
        vector *pvErrDep;
        vector *pvErrIndep;
        Worksheet *pwksData;
        vector *pvYIndep;
        vector<int> *pvintRowsInSource;
};

pstOutInfo: [output]a pointer which points to output structure STGETDATAOUTPUTINFO. Keep it as NULL if the output is not necessary. STGETDATAOUTPUTINFO is defined in OC_types.h:

struct STGETDATAOUTPUTINFO
{
    int nCountNegativeErrorValuesFound;
    int nCountZeroErrorValuesFound;
    int nCountMissingErrorValuesFound;
};

Return

true if successfully, else false.

If it succeeds, it returns the index of the row (if the DRR_BY_ROWS rules bit passed in) or the column from which the main data is drawn, otherwise it returns a negative number.

1 if success.

If it succeeds, it returns the index of the row (if the DRR_BY_ROWS rules bit passed in) or the column from which the main data is drawn, otherwise it returns a negative number.

Examples

EX1

// This example assumes a worksheet with two columns of data is active
void DataRange_GetData_Ex1()
{
    Worksheet wks = Project.ActiveLayer();
    if( !wks )
        return;
    
    DataRange dr;
    dr.Add(wks, 0, "A");
    dr.Add();
    dr.Add(wks, 1, "B");    
    
    vector vA, vB, vAll;
    dr.GetData(&vA, 0); // get the data from Column A
    dr.GetData(&vB, 2); // get the data from Column B
    dr.GetData(&vAll, -1);
}

EX2

// This example assumes a worksheet with one column of data is active
void DataRange_GetData_Ex2(int nXCol = 0)
{
    Worksheet wks = Project.ActiveLayer();
    if( wks )
    {                
        DataRange dr;
        dr.Add(wks, nXCol, "X");
        
        vector vX;
        DWORD dwPlotID;
        dr.GetData(DRR_GET_MISSING | DRR_NO_FACTORS, 0, &dwPlotID, NULL, &vX);
        vX *= 10.0;
        dr.SetData(vX);
    }
}

EX3

// costruct DataRange from Project.ActiveLayer()
void DataRange_GetData_Ex3(string strX = "A", string strY = "B")
{
    // For this example, a workbook with X and Y column data is assumed to be active.
    Worksheet wks = Project.ActiveLayer();
    if(!wks)
    {
        out_str("err, no wks");
        return;
    }
    
    // construct a tree with data from worksheet
    Tree tr;
    if( construct_one_data_range(tr, wks, strX, strY) )    
    {
        out_tree(tr);

        // create the DataRange object from the tree.
        DataRange dr;
        if(dr.Create(tr))
        {
            // Call GetData to copy the xy data into vectors vx and vy
            vector vx, vy;
            DWORD dwPlotID; // this is to receive data plot UID if present
            if(dr.GetData( DRR_GET_MISSING |  DRR_GET_DEPENDENT | DRR_NO_FACTORS, 0, &dwPlotID, NULL, &vy, &vx) < 0)
            {
                out_str("failed to make data copy from data range");
                return;
            }
            
            // now we have made a copy of xy data into vectors vx and vy
            // so we can do analysis on the data, for example:
            double xmin, xmax, ymin, ymax;
            vx.GetMinMax(xmin, xmax);
            vy.GetMinMax(ymin, ymax);
        
        }
        
        // no need to call dr.Destroy().

    }
    // dr is destroyed when go out of scope
}

EX4

// This example assumes a worksheet with three columns of data is active
void DataRange_GetData_Ex4(int nXCol = 0, int nYCol = 1, int nZCol = 2)
{ 
    Worksheet wks = Project.ActiveLayer();
    if( !wks )
    {
        out_str("error, no active worksheet");
        return;
    }                    
            
    DataRange drIn;
    drIn.Add("X", wks, 0, nXCol, -1, nXCol);
    drIn.Add("Y", wks, 0, nYCol, -1, nYCol);
    drIn.Add("Z", wks, 0, nZCol, -1, nZCol);

    vector vX, vY, vZ;
    DWORD dwRules = DRR_GET_MISSING | DRR_GET_Z_DEPENDENT | DRR_NO_FACTORS;
    DWORD dwPlotID;
    // Use this overloaded version of GetData to find out how many rows of XYZ data
    drIn.GetData(dwRules, 0, &dwPlotID, NULL, &vZ, &vX, NULL, NULL, NULL, NULL, NULL, NULL, &vY);
    int iSizeIn = vX.GetSize();
    int iSizeOut = iSizeIn/2 + 1;
    vector<int> vIndicesIn;
    vIndicesIn.Data(0, iSizeIn - 1, 2);
    // Use this overloaded version of GetData with vIndicesIn to extract odd rows to new columns
    drIn.GetData(dwRules, 0, vIndicesIn, vZ, vX, vY);

    string strColDesigs = wks.GetColDesignations();
    nXCol = wks.AddCol("XOut");
    nYCol = wks.AddCol("YOut");
    nZCol = wks.AddCol("ZOut");
    strColDesigs += "XYZ";
    wks.SetColDesignations(strColDesigs);

    DataRange drOut;
    drOut.Add("X", wks, 0, nXCol, -1, nXCol);
    drOut.Add("Y", wks, 0, nYCol, -1, nYCol);
    drOut.Add("Z", wks, 0, nZCol, -1, nZCol);
    drOut.SetData(&vZ, &vY, &vX);
    
}

EX5

// This example assumes 1 or more columns of main data, 1 column of factor or grouping data, and 1 column of weight data(see sample data)
void DataRange_GetData_Ex5(int nXColStart = 0, int nXColEnd = 1, int nFCol = 2, int nWCol = 3)
{
    Worksheet wks = Project.ActiveLayer();
    if( wks )
    {
        DWORD dwRules = DRR_GET_MISSING | DRR_BAD_WEIGHT_TREATMENT;
        DataRange dr;
        dr.Add("X", wks, 0, nXColStart, -1, nXColEnd); // Main data
        dr.Add("F", wks, 0, nFCol, -1, nFCol); // Factor data
        dr.Add("W", wks, 0, nWCol, -1, nWCol); // Weight data
        int nNumData = dr.GetNumData(dwRules);
        vector<string> vstrFactors;
        vector vData, vW;
        double dN, dMean, dMax, dMin;
        for( int ii = 0; ii < nNumData; ii++ )
        {
            int nCol = dr.GetData(dwRules, ii, NULL, NULL, &vData, NULL, NULL, &vstrFactors, &vW);
            if ( 0 <= nCol )
            {
                vData *= vW;
                dN = vData.GetSize();
                vData.Sum(dMean);
                dMean /= dN;
                vData.GetMinMax(dMin, dMax);
                printf("\nColumn = %s, Factor = %s\nMean = %g\nMinimum = %g\nMaximum = %g\n", 
                        wks.Columns(nCol).GetName(), vstrFactors[0], dMean, dMin, dMax);
            }
        }
    }
}

EX6

// This example will create a new worksheet, the first two columns will be filled with 10 rows of random data,
// then even rows are extracted to the last two columns.
void DataRange_GetData_Ex6()
{
    Worksheet wks;
    wks.Create();
    int nXCol,nYCol;
    nXCol=0;
    nYCol=1;
    if( wks )
    {
        while(wks.DeleteCol(0));
        
        wks.AddCol("A");
        wks.AddCol("B");
 
        string strX,strY;
        strX="A";
        strY="B";
        double rr;
        for(int j=0;j<2;j++)
        {
            for (int i=0;i<10;i++)
            {
                   rr=rnd();
                   wks.SetCell(i,j,rr*100);
            }
        }
        DataRange drIn;
        drIn.Add("X", wks, 0, nXCol, -1, nXCol);
        drIn.Add("Y", wks, 0, nYCol, -1, nYCol);

        vector vX, vY;
        DWORD dwRules = DRR_GET_MISSING | DRR_GET_DEPENDENT | DRR_NO_FACTORS;
        DWORD dwPlotID;
        // use this overloaded version of GetData to find out how many rows
        drIn.GetData(dwRules, 0, &dwPlotID, NULL, &vY, &vX);

        int iSizeIn = vX.GetSize();
        int iSizeOut = iSizeIn/2 + 1;
        vector<int> vIndicesIn;
        vIndicesIn.Data(1, iSizeIn - 1, 2);
        // use this overloaded version of GetData with vIndicesIn to extract even rows to new columns
        drIn.GetData(dwRules, 0, vIndicesIn, vY, vX, NULL);

        string strColDesigs = wks.GetColDesignations();
        out_str(strColDesigs);
        nXCol = wks.AddCol();
        nYCol = wks.AddCol();
        strColDesigs += "XY";
        wks.SetColDesignations(strColDesigs);

        DataRange drOut;
        drOut.Add("X", wks, 0, nXCol, -1, nXCol);
        drOut.Add("Y", wks, 0, nYCol, -1, nYCol);
        drOut.SetData(&vY, &vX);
    }
}

EX7

// This example assumes a worksheet with three columns of data is active
void DataRange_GetData_Ex7()
{
    Worksheet wks;
    wks.Create();
    int nXCol,nYCol,nZCol;
    nXCol=0;
    nYCol=1;
    nZCol=2;
    
    if( wks )
    {
        while(wks.DeleteCol(0));
        
        wks.AddCol("A");
        wks.AddCol("B");
        wks.AddCol("C");
        double rr;
        for(int i=0;i<3;i++)
        {
            for (int j=0;j<10;j++)
            {
                   rr=rnd();
                   wks.SetCell(j,i,rr*100);
            }
        ｝
            
        DataRange drIn;
        drIn.Add("X", wks, 0, nXCol, -1, nXCol);
        drIn.Add("Y", wks, 0, nYCol, -1, nYCol);
        drIn.Add("Z", wks, 0, nZCol, -1, nZCol);

        vector vX, vY, vZ;
        DWORD dwRules = DRR_GET_MISSING | DRR_GET_Z_DEPENDENT | DRR_NO_FACTORS;
        DWORD dwPlotID;
        // Use this overloaded version of GetData to find out how many rows of XYZ data
        drIn.GetData(dwRules, 0, &dwPlotID, NULL, &vZ, &vX, NULL, NULL, NULL, NULL, NULL, NULL, &vY);
        int iSizeIn = vX.GetSize();
        int iSizeOut = iSizeIn/2 + 1;
        vector<int> vIndicesIn;
        vIndicesIn.Data(0, iSizeIn - 1, 2);
        // Use this overloaded version of GetData with vIndicesIn to extract odd rows to new columns
        drIn.GetData(dwRules, 0, vIndicesIn, vZ, vX, vY);

        string strColDesigs = wks.GetColDesignations();
        nXCol = wks.AddCol();
        nYCol = wks.AddCol();
        nZCol = wks.AddCol();
        strColDesigs += "XYZ";
        wks.SetColDesignations(strColDesigs);

        DataRange drOut;
        drOut.Add("X", wks, 0, nXCol, -1, nXCol);
        drOut.Add("Y", wks, 0, nYCol, -1, nYCol);
        drOut.Add("Z", wks, 0, nZCol, -1, nZCol);
        drOut.SetData(&vZ, &vY, &vX);
    }
}

EX8

// For this example to run, have two matrices, MBook1 and MBook2, and put some data into MBook2.
void DataRange_GetData_Ex8()
{
    DataRange dr;
    string strRange;
    strRange = "[MBook1]MSheet1!1";
    // Initialize the DataRange object:
    int nn = dr.AddInput(strRange);
    if (nn < 0)
        return;        // failed. Perhaps MBook1 does not exist.

    matrix mm;
    Matrix mat2("MBook2");
    if ( dr.GetData(mm) <= 0 )
    {
        out_str("Failed to get matrix data");
        return;
    }
    // Set the result into mat2:                
    mat2 = mm;
 
    return;
}

EX9

//This example will get the data from the worksheet and do some operation on the data, 
//then put the data to another three columns.
void DataRange_GetData_Ex9()
{
   //Creat a worksheet with XYZ columns and fill with data.
        Worksheet wks;
        wks.Create("origin");
        wks.AddCol();
        wks.SetColDesignations("XYZ");
        for (int ii=0; ii<20; ii++)
        {
                wks.SetCell(ii,0,ii);
                wks.SetCell(ii,1,ii+1);
                wks.SetCell(ii,2,ii*2);
        }
        
    //Get XYZ data.
        DataRange dr;
        dr.Add(wks, 0, "X");
        dr.Add(wks, 1, "Y");
        dr.Add(wks, 2, "Z");
        
        STDRGETDATAARGS gd;
        vector vX,vY,vZ;
        DWORD dwPlotID;
        gd.nIndex = 0;
        gd.pv = &vZ;
        gd.pvIndep = &vX;
        gd.pvYIndep = &vY;
        gd.dwRules = DRR_GET_MISSING |  DRR_GET_Z_DEPENDENT | DRR_NO_FACTORS;
        gd.pouidAux = &dwPlotID;
        
    //To get data from Worksheet XYZ columns to vX, vY, vZ vector.
        dr.GetData(gd);
        
        vX*=10.0;
        vY+=20.0;
        vZ-=30.0;

    //Add XYZ columns in the worksheet.   
        string strColDesigs = wks.GetColDesignations();
    int nXCol = wks.AddCol();
    int nYCol = wks.AddCol();
    int nZCol = wks.AddCol();
    wks.SetColDesignations(strColDesigs);
    
    //Set data in the new columns.
    DataRange drOut;
    drOut.Add(wks, nXCol, "X");
    drOut.Add(wks, nYCol, "Y");
    drOut.Add(wks, nZCol, "Z");
    
    drOut.SetData(&vZ, &vY, &vX);
        
}

EX10

//This example will get the data from the worksheet selection, include label area
void GetDataFromSelection()
{
        Worksheet wks = Project.ActiveLayer();
        if( !wks ) 
                return;
        
        Grid gg;
        int iRegions;      
        vector<int> vr1, vc1, vr2, vc2;    
        if( gg.Attach(wks) ) 
                iRegions = gg.GetSelection(vr1, vc1, vr2, vc2, true);
        
        if( 0 == iRegions )    
        {
                printf("No range selected in %s!", wks.GetName()); 
                return; 
        }             
        
        vector<string> vsData;
        for(int ii = 0 ; ii < iRegions; ii++) 
        {
                DataRange dr;
                dr.Add("Range", wks, vr1[ii], vc1[ii], vr2[ii], vc2[ii]);         
                dr.GetData(vsData, 0);
        }
        out_int("Data Size=", vsData.GetSize());
        out_str(vsData[0]);
}