CSV Data¶
-
class
dataprofiler.data_readers.csv_data.
CSVData
(input_file_path=None, data=None, options=None)¶ Bases:
dataprofiler.data_readers.structured_mixins.SpreadSheetDataMixin
,dataprofiler.data_readers.base_data.BaseData
SpreadsheetData class to save and load spreadsheet data
Data class for loading datasets of type CSV. Can be specified by passing in memory data or via a file path. Options pertaining the CSV may also be specified using the options dict parameter. Possible Options:
options = dict( delimiter= type: str data_format= type: str, choices: "dataframe", "records" selected_columns= type: list(str) header= type: any )
delimiter: delimiter used to decipher the csv input file data_format: user selected format in which to return data can only be of specified types selected_columns: columns being selected from the entire dataset header: any information pertaining to the file header. :param input_file_path: path to the file being loaded or None :type input_file_path: str :param data: data being loaded into the class instead of an input file :type data: multiple types :param options: options pertaining to the data type :type options: dict :return: None
-
data_type
= 'csv'¶
-
property
selected_columns
¶
-
property
delimiter
¶
-
property
quotechar
¶
-
property
header
¶
-
property
data
¶
-
property
data_format
¶
-
property
file_encoding
¶
-
get_batch_generator
(batch_size)¶
-
info
= None¶
-
property
length
¶ Returns the length of the dataset which is loaded.
- Returns
length of the dataset
-
classmethod
is_match
(file_path, options=None)¶ Test the first 1000 lines of a given file to check if the file has valid delimited format or not.
- Parameters
file_path (str) – path to the file to be examined
options (dict) – delimiter read options dict(delimiter=”,”)
- Returns
is file a csv file or not
- Return type
bool
-
reload
(input_file_path=None, data=None, options=None)¶ Reload the data class with a new dataset. This erases all existing data/options and replaces it with the input data/options.
- Parameters
input_file_path (str) – path to the file being loaded or None
data (multiple types) – data being loaded into the class instead of an input file
options (dict) – options pertaining to the data type
- Returns
None
-