| create_csv | Create a new CSV file with headers and optional initial data.
Args:
filename: Name of the CSV file to create (without .csv extension)
headers: List of column headers
data: Optional list of rows, where each row is a list of values
Returns:
Dictionary with creation results and file information
|
| read_csv | Read and return CSV file contents.
Args:
filename: Name of the CSV file to read
limit: Optional limit on number of rows to return
Returns:
Dictionary with file contents and metadata
|
| update_csv | Update a specific cell in the CSV file.
Args:
filename: Name of the CSV file to update
row_index: Zero-based index of the row to update
column: Name of the column to update
value: New value for the cell
Returns:
Dictionary with update results
|
| add_row | Add a new row to the CSV file.
Args:
filename: Name of the CSV file
row_data: Dictionary mapping column names to values
Returns:
Dictionary with addition results
|
| remove_row | Remove a specific row from the CSV file.
Args:
filename: Name of the CSV file
row_index: Zero-based index of the row to remove
Returns:
Dictionary with removal results
|
| get_info | Get basic information about a CSV file.
Args:
filename: Name of the CSV file
Returns:
Dictionary with file metadata and structure information
|
| get_statistics | Get statistical summary of numeric columns in the CSV file.
Args:
filename: Name of the CSV file
Returns:
Dictionary with statistical analysis of numeric columns
|
| filter_data | Filter CSV data based on conditions.
Args:
filename: Name of the CSV file
conditions: Dictionary of column conditions.
Simple: {"column": "value"}
Complex: {"column": {"gt": 5, "lt": 10, "contains": "text"}}
limit: Optional limit on number of rows to return
Returns:
Dictionary with filtered data
|
| sort_data | Sort CSV data by specified columns.
Args:
filename: Name of the CSV file
columns: Column name or list of column names to sort by
ascending: Whether to sort in ascending order
limit: Optional limit on number of rows to return
Returns:
Dictionary with sorted data
|
| group_data | Group and aggregate CSV data.
Args:
filename: Name of the CSV file
group_by: Column name or list of column names to group by
aggregations: Dictionary mapping column names to aggregation functions
(sum, mean, count, min, max, std, etc.)
Returns:
Dictionary with grouped and aggregated data
|
| validate_data | Validate CSV data integrity and format.
Args:
filename: Name of the CSV file
Returns:
Dictionary with validation results, issues, and warnings
|
| delete_csv | Delete a CSV file (with backup if enabled).
Args:
filename: Name of the CSV file to delete
Returns:
Dictionary with deletion results
|
| list_csv_files | List all CSV files in the storage directory.
Returns:
Dictionary with list of CSV files and their metadata
|
| get_path_info | Get detailed information about a file path, supporting both relative and absolute paths.
Args:
filepath: The file path to analyze (can be relative or absolute)
Returns:
Dictionary with comprehensive path information including:
- Whether the path is absolute or relative
- Resolved path (following symlinks)
- Parent directory information
- File existence and accessibility
- Safety validation for absolute paths
|
| create_csv_at_path | Create a new CSV file at a specific path (absolute or relative).
Args:
filepath: Full path where the CSV file should be created
headers: List of column headers
data: Optional list of rows, where each row is a list of values
Returns:
Dictionary with creation results and file information
|
