Data exploration
Jump to navigation
Jump to search
 This article "Data exploration" is still being written. If there are any incomplete parts, you are welcome to directly edit them. 這篇文章「Data exploration」內容還在撰寫中，如果有不完整的部分，歡迎你直接動手修改。
|
Maximum length of characters in a column[edit]
- Excel[1]: =MAX(LEN(Sheet1!A2:Sheet1!A1048576)) where 1048576 is the rows limit of Excel spreadsheet[2].
- MySQL: Using CHAR_LENGTH() function - w3resource e.g. =SELECT MAX(CHAR_LENGTH(`my_column`)) FROM `my_table`
Not using LENGTH() function.
More details on length of characters page.
References[edit]
Data factory flow
- 🔍 Data Collection: 1. How to extract content from websites
- 🧹 Data Cleaning: 2. Data cleaning, 3. Regular expression
- ⚙️ Data Processing: 4. Json encode and decode, 5. Convert between date and unix timestamp, 6. MySQL commands
- 📊 Data Analysis: 7. Data exploration
- 📤 Data Output: 8. Export MySQL query to Excel file, 9. Microsoft Excel
- 🔧 Troubleshooting: 10. Troubleshooting of MySQL errors