Data exploration: Difference between revisions
Jump to navigation
Jump to search
(Created page with " == Maximum length of characters in a column == * Excel: {{kbd | key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadshe...") |
No edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Template:Draft}} | |||
== Maximum length of characters in a column == | == Maximum length of characters in a column == | ||
* Excel: {{kbd | key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadsheet<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>. | * Excel<ref>[https://bensullins.com/excel-tip-identifying-the-max-length-of-values-in-a-column/ Excel Tip: Identifying the max length of values in a column - Ben Sullins | Data Geek]</ref>: {{kbd | key=<nowiki>=MAX(LEN(Sheet1!A2:Sheet1!A1048576))</nowiki>}} where 1048576 is the rows limit of Excel spreadsheet<ref>[https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 Excel specifications and limits - Excel]</ref>. | ||
* MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql- | * MySQL: Using [https://www.w3resource.com/mysql/string-functions/mysql-char_length-function.php CHAR_LENGTH() function - w3resource] e.g. {{kbd | key=<nowiki>=SELECT MAX(CHAR_LENGTH(`my_column`)) FROM `my_table`</nowiki>}} {{exclaim}} Not using [https://www.w3resource.com/mysql/string-functions/mysql-length-function.php LENGTH() function]. | ||
More details on [[PHP_and_MySQL_syntax#Length_of_characters | length of characters]] page. | |||
== | == References == | ||
<references/> | <references/> | ||
{{Template: | {{Template:Data factory flow}} | ||
[[Category:Spreadsheet]] | [[Category:Spreadsheet]] | ||
Latest revision as of 11:32, 15 July 2025
 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. Comparison of common data file formats, 9. Export MySQL query to Excel file, 10. Microsoft Excel
- 🔧 Troubleshooting: 11. Troubleshooting of MySQL errors