Hub

20 results

Filter
Filter by tag
R
Import
Knime Csv Readr Library Read Arrow Gzip Parquet
  1. Workflow
    Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files
    Excel Import Sheet
    +17
    Import EXCEL - This workflow will act as a meta workflow trying to answer questions about importing data from Excel files One of …
    mlauber71 > Public > kn_example_excel_import_meta_workflow
    1
    mlauber71
  2. Workflow
    Import DBF (dBase) file with the help of R's foreign library or Python packages
    Dbf Dbase File
    +5
    Import DBF (dBase) file with the help of R's foreign library or Python packages
    mlauber71 > Public > forum > kn_forum_1782_dbf_import_dbase_file_r
    1
    mlauber71
  3. Workflow
    import messy CSV file with double quotes and unmatched quotes at beginning and end (forum 44692)
    Csv Import Messy
    +3
    import messy CSV file with double quotes and unmatched quotes at beginning and end (forum 44692)
    mlauber71 > Forum > 2022 > kn_forum_44692_csv_file_comma
    0
    mlauber71
  4. Workflow
    Import messy CSV file
    Csv Readr R
    +2
    Import messy CSV file
    mlauber71 > Public > forum > kn_forum_26453_import_csv_messy_file
    0
    mlauber71
  5. Workflow
    use R library(arrow) to read parquet file into KNIME
    Parquet Arrow Import
    +5
    use R library(arrow) to read parquet file into KNIME Export the data to SQLite, ARFF and again to another Parquet file. Also: spl…
    mlauber71 > Public > kn_example_r_read_parquet_file
    0
    mlauber71
  6. Workflow
    Force R’s readr to import all columns of a CSV file as strings
    Csv Import Force
    +6
    Force R’s readr to import all columns as strings ——— library(readr) file_location <- knime.flow.in[["Location"]] knime.out <- as.…
    mlauber71 > Public > kn_example_r_import_csv_r_readr_force_all_string
    0
    mlauber71
  7. Workflow
    Force R’s readr to import all columns of a messy CSV file as strings - allow changing table structures
    Csv Import Force
    +6
    Force R’s readr to import all columns of a messy CSV file as strings - allow changing table structures ——— library(readr) file_lo…
    mlauber71 > Public > kn_example_r_import_csv_messy_loop_force_all_string
    0
    mlauber71
  8. Workflow
    use R library(readr) to read (messy) CSV file into KNIME
    Parquet Arrow Import
    +7
    use R library(readr) to read (messy) CSV file into KNIME Export the data to SQLite, ARFF and Parquet and demonstrate to read the …
    mlauber71 > Public > kn_example_r_read_single_csv_file
    0
    mlauber71
  9. Workflow
    Import Excel/XLSX file with R's openxlsx package
    KNIME Excel Import
    +3
    Import Excel/XLSX file with R's openxlsx package
    mlauber71 > Public > kn_example_r_openxlsx_read_excel_file
    0
    mlauber71
  10. Workflow
    CSV Reader new with carriage return
    R Csv Import
    +3
    CSV Reader new with carriage return
    mlauber71 > Public > forum > kn_forum_30216_minimal_csv_example
    0
    mlauber71
  11. Workflow
    Read tables from Word documents (.docx) and import them into KNIME
    R Knime Import
    +7
    usage of R package docxtractr to import tables from a Word document In this example we have a changing table structure which is c…
    mlauber71 > Public > kn_example_r_docx_import_table3
    0
    mlauber71
  12. Workflow
    use R library(readxl) to read XLSX/Excel file into KNIME
    Parquet Arrow Import
    +7
    use R library(readxl) to read XLSX/Excel file into KNIME Export the data to SQLite, ARFF and Parquet and demonstrate to read the …
    mlauber71 > Public > kn_example_r_read_single_xlsx_file
    0
    mlauber71
  13. Workflow
    Import CSV data with R's readr
    Import Knime R
    +1
    use R package readr to import more complex CSV and text files into KNIME
    mlauber71 > Public > kn_example_import_csv_r_readr
    0
    mlauber71
  14. Workflow
    m_001_import_r_excel_unite_fields
    R Excel Knime
    +8
    use R to list excel sheet names, extract the data and keep only columns that are present in all sheets use R package readxl to li…
    mlauber71 > Public > kn_example_r_excel_find_united_fields > m_001_import_r_excel_unite_fields
    0
    mlauber71
  15. Workflow
    Read tables from Word documents (.docx) and import them into KNIME.
    R Knime Import
    +4
    usage of R package docxtractr to import tables from a Word document
    mlauber71 > Public > kn_example_r_docx_import_table
    0
    mlauber71
  16. Workflow
    use R to list excel sheet names
    R Excel Knime
    +4
    use R package readxl to list all sheets of excel files from a folder
    mlauber71 > Public > kn_example_r_excel_multiple_sheets > m_001_import
    0
    mlauber71
  17. Workflow
    use R package gdata to import older Excel files
    R KNIME Excel
    +1
    use R package gdata to import older Excel files
    mlauber71 > Public > kn_example_excel_old_files_import
    0
    mlauber71
  18. Workflow
    Read tables from Word documents (.docx) and import them into KNIME.
    R Knime Import
    +4
    usage of R package docxtractr to import tables from a Word document
    mlauber71 > Public > kn_example_r_docx_import_table2
    0
    mlauber71
  19. Workflow
    use R library(readxl) to read XLSX/Excel file into KNIME and skipt the first 3 rows
    Import Knime Read
    +4
    use R library(readxl) to read XLSX/Excel file into KNIME and skipt the first 3 rows
    mlauber71 > Public > kn_example_r_read_xlsx_file_skip_lines
    0
    mlauber71
  20. Workflow
    use R library (readr) to read CSV file into KNIME with UTF-16LE encoding
    Parquet Arrow Import
    +7
    use R library (readr) to read CSV file into KNIME with UTF-16LE encoding locale = locale(encoding = "UTF-16LE")
    mlauber71 > Public > kn_example_r_readr_locale_encoding
    0
    mlauber71