[B! csv] msh514ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

msh514 id:msh514

csvã«é–¢ã™ã‚‹msh514ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

xlsxãƒ•ã‚¡ã‚¤ãƒ«ã«SQLã‚’å®Ÿè¡Œã™ã‚‹xlsxsql - Qiita
xlsxãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾ã—ã¦SQLã‚’å®Ÿã§ãã‚‹xlsxsqlã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ä½œã‚Šã¾ã—ãŸã€‚ GitHubã®xlsxsqlã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ã“ã‚Œã¯ä½•ï¼Ÿ xlsxsqlã¯ã€xlsxãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾ã—ã¦SQLã‚’å®Ÿè¡Œã™ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ã¾ãŸã€CSV,LTSV,JSON,YAMLã¨ã„ã£ãŸãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾ã—ã¦SQLã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã‚‚ã§ãã€ãã®çµæžœã‚’xlsxãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ trdsqlã«xlsxãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿æ›¸ãæ©Ÿèƒ½ã‚’è¿½åŠ ã—ãŸã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ ä½¿ã„æ–¹ å˜ç´”ã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã—ã¦æŒ‡å®šã§ãã¾ã™ã€‚ -oã¾ãŸã¯-outã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¯å‡ºåŠ›ãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã‚’æŒ‡å®šã—ã¾ã™ã€‚ CSV, LTSV, JSON, JSONL, YAML, TBLN, AT, MDç‰ãŒæŒ‡å®šã§ãã¾ã™ã€‚
msh514 2023/11/24
SQL

ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰

csv

ãƒ„ãƒ¼ãƒ«

python
ãƒªãƒ³ã‚¯
pandas.DataFrame.to_excel â€” pandas 2.2.2 documentation
msh514 2021/01/05
python

csv

excel

import

read

write

to_excel
ãƒªãƒ³ã‚¯
Pythonã§CSVãƒ‡ãƒ¼ã‚¿ã‚’Excelã«è²¼ã‚Šä»˜ã‘ã‚‹
msh514 2021/01/05
python

csv

excel

import

read

write
ãƒªãƒ³ã‚¯
csvã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€ç‰¹å®šã®ã‚»ãƒ«ã‚’æŒ‡å®šã—ã¦è²¼ã‚Šä»˜ã‘ãŸã„
å‰æãƒ»å®Ÿç¾ã—ãŸã„ã“ã¨ csvã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ”ãƒ¼ã—ã€ã‚¨ã‚¯ã‚»ãƒ«ã®ç‰¹å®šã®ã‚»ãƒ«ã‚’æŒ‡å®šã—ã¦ã€ ãã®ã‚»ãƒ«ã‚’èµ·ç‚¹ã¨ã—ã¦è²¼ã‚Šä»˜ã‘ãŸã„ã§ã™ã€‚ ï¼ˆè²¼ã‚Šä»˜ã‘å…ˆã‚’æŒ‡å®šã§ãã‚Œã°ã€ã‚¨ã‚¯ã‚»ãƒ«ã§ã¯ãªãcsvãƒ•ã‚¡ã‚¤ãƒ«ã«è²¼ã‚Šä»˜ã‘ã‚‹ã®ã§ã‚‚å•é¡Œãªã„ã§ã™ã€‚ï¼‰ ä¾‹ãˆã°ã€ä¸‹è¨˜ã®ã‚ˆã†ã«è¤‡æ•°ã‚»ãƒ«ã«ã¾ãŸãŒã£ã¦ã„ã‚‹æƒ…å ±ã™ã¹ã¦ã‚’ã‚³ãƒ”ãƒšã—ã¦ã€ ã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®A2ã‚»ãƒ«ãŒèµ·ç‚¹ã«ãªã‚‹ã‚ˆã†ã«è²¼ã‚Šä»˜ã‘ãŸã„ã§ã™ã€‚ A1 B1 data_1 0 1 data_2 0 2 ï¼ˆã¡ãªã¿ã«ã§ã™ãŒã€ã“ã®ã‚ã¨ã€è¤‡æ•°ã®csvãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã¿ã€ ãã‚Œãžã‚Œã€åŒã˜ãƒ•ã‚¡ã‚¤ãƒ«ä¸Šã§åˆ¥ã®è²¼ã‚Šä»˜ã‘å…ˆã®ã‚»ãƒ«ã‚’æŒ‡å®šã—ã¦ã€è²¼ã‚Šä»˜ã‘ãŸã„ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ï¼‰ ç™ºç”Ÿã—ã¦ã„ã‚‹å•é¡Œãƒ»ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ Traceback (most recent call last): File "C:/Users/xx/Desktop/test/merge_csv_test.py", line 11, in <modu
msh514 2021/01/05
python

csv

excel

import

read

write
ãƒªãƒ³ã‚¯
ã€Pythonã€‘CSVã‚’é–‹ã„ã¦ã‚¨ã‚¯ã‚»ãƒ«ã«è²¼ã‚Šä»˜ã‘ã‚‹æ–¹æ³•ï½œç‹¬å¦ç´ äººã®é™ç•Œçªç ´Blog
CSVã‚’é–‹ã„ã¦ã‚¨ã‚¯ã‚»ãƒ«ã«è²¼ã‚Šä»˜ã‘ã‚‹æ–¹æ³•ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ããŸCSVã‚’é–‹ã„ã¦ã€åˆ¥ã®ã‚¨ã‚¯ã‚»ãƒ«ã«è²¼ã‚Šä»˜ã‘ã‚‹æ–¹æ³•ã€‚ # -*- coding: utf-8 -*- import pandas as pd import openpyxl # csvãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã‚€ frame = pd.read_csv(r"C:\Users\oono\Desktop\aaaa.csv",encoding='Shift_JIS') # ã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãè¾¼ã‚€ writer = pd.ExcelWriter(r"C:\Users\oono\Desktop\aaaa.xlsx") frame.to_excel(writer,'Sheet1',index=False) # header=False #ã€€ä¿å˜ writer.save()
msh514 2021/01/05
python

csv

excel

import

read

write
ãƒªãƒ³ã‚¯
Pythonã§ã„ã„æ„Ÿã˜ã«ãƒãƒƒãƒã‚’ä½œã£ã¦ã¿ã‚‹ - prefectã‚’ã¯ã˜ã‚ã‚ˆã† - JXé€šä¿¡ç¤¾ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
JXé€šä¿¡ç¤¾ã‚·ãƒ‹ã‚¢ãƒ»ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§, ãƒ—ãƒãƒ€ã‚¯ãƒˆãƒãƒ¼ãƒ ã®ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã¨ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹ã®ã‚ã‚Œã“ã‚Œé ‘å¼µã£ã¦ã‚‹ãƒžãƒ³, @shinyorkeï¼ˆã—ã‚“ã‚ˆãƒ¼ãï¼‰ã§ã™. æœ€è¿‘ãƒãƒžã£ã¦ã‚‹ã‹ã¤æ¯Žæœã®æ—¥èª²ã¯ã€Œãƒªãƒ³ã‚°ãƒ•ã‚£ãƒƒãƒˆã‚¢ãƒ‰ãƒ™ãƒ³ãƒãƒ£ãƒ¼*1ã§æ±—ã‚’æµã—ã¦ã‹ã‚‰ã®æœé£Ÿã€ã§ã™. 35æ—¥é€£ç¶šç¶šã„ã¦ã„ã¾ã™. è©±ã¯é¡ã‚‹ã“ã¨ä»Šå¹´ã®7æœˆæœ«ã«ãªã‚Šã¾ã™ãŒ, JXé€šä¿¡ç¤¾ã®ãƒ‡ãƒ¼ã‚¿åŸºç›¤ã®ç´¹ä»‹&ã€ŒETLã¨ã‹ãƒãƒƒãƒã£ã¦ã©ã®FW/ãƒ©ã‚¤ãƒ–ãƒ©ãƒªä½¿ãˆã°ã„ã„ã®ã•ðŸ¤”ã€ã¨ã„ã†ã‚¯ã‚¨ã‚¹ãƒãƒ§ãƒ³ã«å¿œãˆã‚‹ãŸã‚, ã“ã®ã‚ˆã†ãªã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’å…¬é–‹ã—ã¾ã—ãŸ. tech.jxpress.net ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼, å¤šãã®æ–¹ã‹ã‚‰åéŸ¿ã‚’ã„ãŸã ãåŸ·ç†ã—ã¦ã‚ˆã‹ã£ãŸã§ã™, èªã‚“ã§ãã ã•ã£ãŸæ–¹ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼ ã¾ã ãŠèªã¿ã§ãªã„æ–¹ã¯ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’èªã¿é€²ã‚ã‚‹å‰ã«æµã—ã¦èªã‚“ã§ã‚‚ã‚‰ãˆã‚‹ã¨è‰¯ã„ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“. ä¸Šè¨˜ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®æœ€å¾Œã§, æ¬¡ã¯prefectç·¨ã§ä¼šã„ã¾ã—ã‚‡ã†. ã¨ã„ã†æŒ¨æ‹¶ã§ç· ã‚ã•ã›
msh514 2020/12/19
csv

ãƒ‡ãƒ¼ã‚¿

python
ãƒªãƒ³ã‚¯
ã€Pythonã€‘Pandasã§CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã¿/æ›¸ãå‡ºã—ã™ã‚‹å®Ÿè·µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯é›†
ã“ã®è¨˜äº‹ã¯ã€Pythonã®Pandasãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã—ã¦ã€CSVãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿æ›¸ãã‚’ã™ã‚‹å®Ÿè·µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ã¾ã¨ã‚ãŸã‚‚ã®ã«ãªã£ã¦ã„ã¾ã™ã€‚ Pythonã§CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡¦ç†ã™ã‚‹æ–¹æ³•ã¯Pandasä»¥å¤–ã«ã‚‚ãŸãã•ã‚“ã‚ã‚Šã¾ã™ãŒã€ç§ã¯Pandasä¸€æŠžæ´¾ã§ã™ã€‚ Pandasã¯ãƒ‡ãƒ¼ã‚¿ã®åŠ å·¥ãƒ»åˆ†æžã«ç‰¹åŒ–ã—ãŸãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« ä½•åƒä½•ä¸‡è¡Œã«æ¸¡ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã§ã‚‚é«˜é€Ÿã«å‡¦ç†ã§ãã‚‹ è¤‡æ•°ã®CSVã‚’ã¾ã¨ã‚ã¦å‡¦ç†ã§ãã‚‹ NumPyã‚„SciPyã€Matplotlibãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨è¦ªå’Œæ€§ãŒã‚ã‚‹
msh514 2020/04/14
python

pandas

csv
ãƒªãƒ³ã‚¯
MySQLãƒªãƒ¢ãƒ¼ãƒˆDBã®çµæžœã‚’ãƒãƒ¼ã‚«ãƒ«CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã™ã‚‹æ–¹æ³• | é–‹ç™ºãƒ¡ãƒ¢ã‚‹ã‚¢ãƒ«
MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã—ãŸã„å ´åˆã€ SELECT â€¦ INTO OUTFILE æ§‹æ–‡ã‚’ä½¿ã†ã®ãŒã‚ˆãã‚ã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ãªã®ã§ã™ãŒã€ DBã‚µãƒ¼ãƒãƒ¼ãŒãƒªãƒ¢ãƒ¼ãƒˆãƒ›ã‚¹ãƒˆä¸Šã«ã‚ã‚‹å ´åˆã¯ã“ã®æ–¹æ³•ãŒä½¿ãˆã¾ã›ã‚“ã€‚ CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã§ã€ãƒªãƒ¢ãƒ¼ãƒˆDBã®çµæžœã‚’ãƒãƒ¼ã‚«ãƒ«CSVãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã§ãã¾ã™ã€‚ æ§‹æ–‡ mysql -u [ãƒ¦ãƒ¼ã‚¶ãƒ¼å] -p -h [DBã‚µãƒ¼ãƒãƒ¼ãƒ›ã‚¹ãƒˆå] [DBå] -e "`cat [å®Ÿè¡ŒSQLãƒ•ã‚¡ã‚¤ãƒ«å]`" | sed -e 's/\t/,/g' > [å‡ºåŠ›CSVãƒ•ã‚¡ã‚¤ãƒ«ãƒ‘ã‚¹] å®Ÿè¡Œä¾‹ $ mysql -u test -p -h dbhost testdb -e "`cat outcsv.sql`" | sed -e 's/\t/,/g' > /tmp/test.csv ã„ã‚ã„ã‚èª¿ã¹ãŸçµæžœãŸã©ã‚Šç€ã„ãŸã®ãŒä»¥ä¸Šã®æ–¹æ³•ã§ã™ã€‚ ç†ç”±ã¨ã‹æ°—ã«ãªã‚‰ãªã„äººã¯
msh514 2019/09/06
mysql

csv

DB

é–‹ç™º

SQL

export

remote
ãƒªãƒ³ã‚¯
Spring Boot + Flywayã§ã‚³ãƒ¼ãƒ‰ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ - Qiita
Spring Bootã§Flywayã‚’ä½¿ã£ã¦ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œãªã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€åˆæœŸãƒ‡ãƒ¼ã‚¿ã‚’CSVã‹ã‚‰åŠ å·¥ã—ã¦æŠ•å…¥ã—ãŸã„ã“ã¨ãŒã‚ã£ãŸã®ã§ã€ã‚³ãƒ¼ãƒ‰ã«ã‚ˆã‚‹ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ Java-based migrations Java-based migrationsã®ãƒšãƒ¼ã‚¸ã«æ›¸ã„ã¦ã‚ã‚‹æ‰‹é †ã§ã€CSVã‚’å–ã‚Šè¾¼ã‚“ã§åŠ å·¥ã™ã‚‹Javaã‚¯ãƒ©ã‚¹ã‚’ä½œæˆã—ã¾ã™ã€‚ ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ã®Javaã‚¯ãƒ©ã‚¹ä½œæˆ src/main/javaé…ä¸‹ã«db.migrationé…ä¸‹ã«ã“ã¡ã‚‰ã®ãƒšãƒ¼ã‚¸ã«æ›¸ã„ã¦ã‚ã‚‹å‘½åå½¢å¼ã§ã‚¯ãƒ©ã‚¹ã‚’ä½œæˆã—ã¾ã™ã€‚ åŸºæœ¬çš„ã«ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ç”¨ã®SQLã®å‘½åè¦å‰‡ã¨åŒã˜ã§ã™ã€‚ ä½œæˆã—ãŸã‚¯ãƒ©ã‚¹ã«JdbcMigrationã‚‚ã—ãã¯SpringJdbcMigrationã‚’ç¶™æ‰¿ã—ã¾ã™ã€‚ ä»Šå›žã¯Spring Bootã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã§ã€SpringJdbcMigrationã‚’ç¶™æ‰¿ã—ã€migrateãƒ¡ã‚½ãƒƒãƒ‰
msh514 2019/07/25
flyway

import

csv
ãƒªãƒ³ã‚¯
Pythonã§csvãƒ•ã‚¡ã‚¤ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãè¾¼ã¿ã‚’ã™ã‚‹åŸºæœ¬ä¸ã®åŸºæœ¬
ã¿ãªã•ã‚“ã€ã“ã‚“ã«ã¡ã¯ï¼ ã‚¿ã‚«ãƒã‚·(@ntakahashi0505)ã§ã™ã€‚ éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼†Windowsãƒ¦ãƒ¼ã‚¶ãƒ¼å‘ã‘Pythonã§ã‚¯ãƒªãƒƒãƒ—ãƒœãƒ¼ãƒ‰ã‚’ä½¿ã£ãŸä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã‚’ä½œã‚‹ã‚·ãƒªãƒ¼ã‚ºã§ã™ã€‚ å‰å›žã®è¨˜äº‹ã¯ã‚³ãƒãƒ©ã€‚
msh514 2019/07/23
python

csv
ãƒªãƒ³ã‚¯
Python ã§å¤§é‡ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¸¦åˆ—ã§é€Ÿãèªã¿è¾¼ã‚€ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
msh514 2019/06/03
python

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

pandas

CSV
ãƒªãƒ³ã‚¯
ã€Pythonå®Ÿè·µã€‘Pythonã§Excelæ“ä½œï¼ãƒžã‚¯ãƒã§ä»•äº‹ã‚’è‡ªå‹•åŒ–ã—ã‚ˆã† | ä¾ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
Pythonã§ä»•äº‹ãŒè‡ªå‹•åŒ–ã§ãã‚‹ã‚‰ã—ã„ã‘ã©ã€ã©ã†ã‚„ã£ã¦ã„ã„ã®ã‹ã‚ã‹ã‚‰ãªã„ãƒ»ãƒ»ãƒ» ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãŒã‚ˆãã‚ã‹ã‚‰ã„ã‘ã©ã€Pythonã§ãƒžã‚¯ãƒã‚’çµ„ã‚€ã¨ã„ã‚ã„ã‚ä¾¿åˆ©ã ã£ã¦èžã„ãŸ Pythonã¯åˆå¦è€…å‘ã‘ã¨ã—ã¦æœ‰åãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã§ã™ã€‚ãã®ã‚ã‹ã‚Šã‚„ã™ã•ã‹ã‚‰ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å°‚é–€ã¨ã—ãªã„æ–¹ã®ä¸ã«ã‚‚ã€ä»•äº‹ã®è‡ªå‹•åŒ–ã‚’ç›®çš„ã¨ã—ã¦Pythonã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ãŒãŸãã•ã‚“ã„ã¾ã™ã€‚ä»Šå›žã¯ãã‚“ãªä»•äº‹ã®è‡ªå‹•åŒ–ã«ç„¦ç‚¹ã‚’çµžã‚Š
msh514 2019/05/15
python

csv

excel
ãƒªãƒ³ã‚¯
1