def display_data(value):
"""Displaying the head for the selected file."""
db_value = db.get("file")
if value is None and db_value is None:
return ""
elif value is None and not db_value is None:
value = db_value
format = FileUtils.file_format(value)
if format == 'csv' or format == 'txt':
path = FileUtils.path('raw', value)
head = DataUtils.read_text_head(path)
table_col = [
html.Col(style={'width': "10%"}),
html.Col(style={'width': "90%"})
]
table_header = [
html.Thead(html.Tr([html.Th("Row No"),
html.Th("Data")]))
]
rows = []
for i in range(len(head)):
row = html.Tr([html.Td(i + 1), html.Td(head[i])])
rows.append(row)
table_body = [html.Tbody(rows)]
table = dbc.Table(table_col + table_header + table_body,
bordered=True,
style=common.table_style)
div = [
common.msg("Selected File: " + value),
common.msg("Selected Format: " + format), table,
html.Br(), csv_properties_div
]
elif format == 'xls' or format == 'xlsx':
path = FileUtils.path('raw', value)
xls = pd.ExcelFile(path)
sheets = xls.sheet_names
div = [
common.msg("Selected File: " + value),
common.msg("Selected Format: " + format),
common.msg("Select Sheet:"),
html.Div([
dcc.Dropdown(id='xls-file-sheet',
options=[{
'label': sheet,
'value': sheet
} for sheet in sheets],
value=None,
multi=False)
],
style={
'margin': '10px',
'width': '50%'
}),
html.Div([], id="display-xls-file")
]
else:
div = "Format Not Supported!!"
db.put("file", value)
db.put("format", format)
return div
def read_text_head(path: str):
format = FileUtils.file_format(path)
op = None
if format == 'csv' or format == 'txt':
with open(path) as myfile:
head = [next(myfile).strip() for x in range(N)]
op = head
return op
def read(dir: str, filename: str):
format = FileUtils.file_format(filename)
path = FileUtils.path(dir, filename)
op = None
if format == 'csv' or format == 'txt':
with open(path) as myfile:
head = [next(myfile).strip() for x in range(N)]
op = head
elif format == 'jpeg' or format == 'jpg' or format == 'gif':
""
else:
op = "Format Not Supported!!"
return op