# Path: dcs/load.py
# def guessEncoding(filename):
# def convertEncoding(filename, source="utf-8", destination="utf-8", buffer=1024):
# def CSVtoDataFrame(filename, header=0, initialSkip=0, sampleSize=100, seed=None, headerIncluded=True):
# def JSONtoDataFrame(filename, sampleSize=100, seed=None):
# def XLSXtoDataFrame(filename, initialSkip=0, sampleSize=100, seed=None, headerIncluded=True):
# def dataFrameToJSON(df, rowIndexFrom=None, rowIndexTo=None, columnIndexFrom=None, columnIndexTo=None):
# def renameColumn(df, column, newName):
# def emptyStringToNan(df, columnIndex):
# def newCellValue(df, columnIndex, rowIndex, newValue):
# def removeRows(df, rowIndices):
# def removeColumns(df, columnIndices):
# def rowsWithInvalidValuesInColumns(df, columnIndices):
# def duplicateRowsInColumns(df, columnIndices):
# def outliersTrimmedMeanSd(df, columnIndices, r=2, k=0):
# def changeColumnDataType(df, column, newDataType, dateFormat=None): 


import numpy as np
import pandas as pd
import pytest
import datetime
from dcs import load

d = {'col1' : pd.Series([1.], index=[0]),
     'col2' : pd.Series([1., 2.], index=[0, 1])}

df = pd.DataFrame(d)


#--------------------------------(CSV to dataframe)-----------------------------

#test converting a CSV file to a pandas dataframe
def test_CSVtoDataframe1():

# Path: dcs/load.py
# def guessEncoding(filename):
# def convertEncoding(filename, source="utf-8", destination="utf-8", buffer=1024):
# def CSVtoDataFrame(filename, header=0, initialSkip=0, sampleSize=100, seed=None, headerIncluded=True):
# def JSONtoDataFrame(filename, sampleSize=100, seed=None):
# def XLSXtoDataFrame(filename, initialSkip=0, sampleSize=100, seed=None, headerIncluded=True):
# def dataFrameToJSON(df, rowIndexFrom=None, rowIndexTo=None, columnIndexFrom=None, columnIndexTo=None):
# def renameColumn(df, column, newName):
# def emptyStringToNan(df, columnIndex):
# def newCellValue(df, columnIndex, rowIndex, newValue):
# def removeRows(df, rowIndices):
# def removeColumns(df, columnIndices):
# def rowsWithInvalidValuesInColumns(df, columnIndices):
# def duplicateRowsInColumns(df, columnIndices):
# def outliersTrimmedMeanSd(df, columnIndices, r=2, k=0):
# def changeColumnDataType(df, column, newDataType, dateFormat=None): 


# Path: dcs/testing/test_load_module.py
import numpy as np
import pandas as pd
import pytest
import datetime
from dcs import load


d = {'col1' : pd.Series([1.], index=[0]),
     'col2' : pd.Series([1., 2.], index=[0, 1])}

df = pd.DataFrame(d)


#--------------------------------(CSV to dataframe)-----------------------------

#test converting a CSV file to a pandas dataframe
def test_CSVtoDataframe1():

	testing_df = load.CSVtoDataFrame('inputCSV.csv')