Skip to content

2.-file.md

Latest commit

 

History

History
86 lines (45 loc) · 3.07 KB

2.-file.md

File metadata and controls

86 lines (45 loc) · 3.07 KB
description Read or Write a File

2. File

  1. Click on the File in the Data Analysis category.

  1. Choose whether to read or save a file from the top bar

2-1. You can use sample data prepared by Visual Python through Sample Data.

Read File

  1. Select the type of file to load.
  2. Choose the file path.
  3. Enter the variable name (Callable name, Identifier) for the file.

  1. Additional Options allow various settings.

4-1. If not set separately, the default values set by Visual Python will be applied.

4-2. Any settings not found here can be entered in the User Option for configuration.

  1. Encoding: Specify the encoding of the file.
  2. Header: Select None if you do not want to use column names.

6-1. By default, the values entered in the first row are set as column names.

  1. Separator: Choose the delimiter that separates the data fields in the file.
  2. Columns: You can set column names by entering a pre-made list or specific values.
  3. Column List to Use: Specify specific columns to load from multiple columns in the file.
  4. Column to Use as Index: Specify the column from the file's columns to use as an index.
  5. Na Values: Represent missing values with the specified input.
  6. Rows to Skip: Specify the number of rows to ignore at the beginning of the file.
  7. Number of Rows: Read only the specified number of rows from the beginning.
  8. Chunksize: Divide the file into separate parts and read them to create separate DataFrames. Helpful in handling large files.

Write File

  1. Select the type to save.
  2. Choose the DataFrame to save.
  3. Select the location to save.
  4. Additional Options allow various settings.

4-1. If not set separately, the default values set by Visual Python will be applied.

4-2. Any settings not found here can be entered in the User Options for configuration.

  1. Encoding: Specify the encoding of the file.
  2. Header: Choose False to exclude column names when saving.

6-1. By default, column names are saved as the first row.

  1. Index: Choose False to exclude the index when saving.

7-1. By default, the index is saved as the first column.

  1. Separator: Choose the delimiter that separates the data fields in the file.
  2. Na Replacing Value: Replace missing values with the specified input when saving.
  3. Columns: You can save only specific columns.