Chapter 9: Coding and File Management
9.1 Coding (Qualitative Analysis)
Coding is a feature for assigning qualitative data analysis codes (labels/classification tags) to collected data.
Purpose of Coding:
- Assign thematic classifications to collected data
- Use as categorical variables during model building
- Identify patterns and trends in data
Steps:
- Select the “Coding” tab in the left sidebar
- Select the target CSV project and file
- Data loads and displays in the table
Creating Codes:
- Manual creation: Enter code names in the text input field to add
- AI suggestions: Click “AI Code Suggestion” to have AI suggest codes based on data content
Applying Codes:
- Select codes from each data row’s dropdown to assign
- Multiple codes can be assigned simultaneously
Export:
- “Export Codebook CSV” downloads a code-annotated CSV
- The code columns in the exported CSV can be used as categorical variables in ConceptMap-Text
9.2 File Management
Features for importing, merging, previewing, and editing CSV files.
CSV Import
Steps:
- Select the “File Management” tab in the left sidebar
- Click the “CSV Import” button
- Select a .csv or .tsv file in the file dialog
- The file uploads to the project
Supported Formats:
- CSV (comma-separated)
- TSV (tab-separated)
Character Encoding: UTF-8 recommended. Shift-JIS files may have character encoding issues.
CSV Merge
Merge multiple CSV files into one.
Steps:
- Check the checkboxes for files to merge (select 2 or more)
- A “Merge” button appears
- Click “Merge”
- Selected files are combined into one new CSV file
- “Clear Selection” button to deselect
Note: Merged files should ideally have the same column structure. If columns differ, all columns are included in the merged result, with empty cells where data doesn’t exist.
CSV Preview and Editing
Preview Display:
- Click the eye icon in the file list
- Data displays in table format in the main area
Edit Mode:
- Click “Edit” while in preview
- Table cells become editable
- Click cells to edit content directly
- Delete button removes unwanted rows
- “Save” to confirm changes
- “Cancel” to discard changes
Download:
- “Download” button during preview downloads the CSV file locally
CSV File Encoding: CSV files downloaded from ThinkNavi include a UTF-8 BOM (Byte Order Mark), ensuring Japanese characters display correctly when opened directly in Excel.
9.3 Troubleshooting
| Issue | Cause and Solution |
|---|---|
| Imported CSV shows garbled characters | Ensure the file is saved in UTF-8. Convert Shift-JIS files to UTF-8 before importing |
| Merge button not displayed | Check at least 2 files |
| Edits not saved | Click the “Save” button. Unsaved edits are lost when reloading the browser |
| Downloaded CSV shows garbled characters in Excel | When opening CSV in Excel, import via “Data” → “From Text” specifying UTF-8. Or open via “File > Open” instead of double-clicking |