[B! pandas] icicaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

icica id:icica

pandasã«é–¢ã™ã‚‹icicaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{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}}

ã¾ã Excelã§æ¶ˆè€—ã—ã¦ã‚‹ã®ï¼ŸPythonã«ã‚ˆã‚‹è‡ªå‹•é›†è¨ˆã‚¬ã‚¤ãƒ‰ åŸºç¤Žç·¨ - Qiita
ã¡ã‚‡ã£ã¨ã—ãŸãƒ‡ãƒ¼ã‚¿ã®åŠ å·¥ã‚„é›†è¨ˆã«ã€Excelã‚„Google Spreadsheetã¯ä¾¿åˆ©ã§ã™ãŒã€ãã‚ŒãŒæ—¥å¸¸çš„ãªä½œæ¥ã«ãªã£ã¦ã—ã¾ã£ãŸã‚‰è‡ªå‹•åŒ–ã—ãŸã„ã§ã™ã‚ˆãï¼Ÿ ãã“ã§ãŠå‹§ã‚ãªã®ãŒpandasã§ã™ã€‚ Pandasã¯ Python ç”¨ã®ãƒ‡ãƒ¼ã‚¿å‡¦ç†ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã‚ã‚Šã€Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚„CSVãªã©ã®è¡¨å½¢å¼ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿ã“ã¿ã€åŠ å·¥ã‚„é›†è¨ˆã—ãŸä¸Šã§ã€å‡ºåŠ›ã™ã‚‹ã¨ã„ã£ãŸã“ã¨ãŒãƒ—ãƒã‚°ãƒ©ãƒ ã§è¨˜è¿°ã§ãã¾ã™ã€‚ã¾ãŸé–‹ç™ºç’°å¢ƒã‚’ç”¨æ„ã—ãªãã¨ã‚‚ã€GoogleãŒæä¾›ã™ã‚‹ç„¡æ–™ã®é–‹ç™ºç’°å¢ƒã§ã‚ã‚‹Colaboratoryä¸Šã§ã€ã™ãã«è©¦ã™ã“ã¨ãŒã§ãã¾ã™ã€‚ ãã—ã¦Pythonã¯ã€Office 98ä»¥é™20å¹´ä»¥é™æ›´æ–°ã•ã‚Œã¦ã„ãªã„VBAã«ä»£ã‚ã‚‹æ–°ãŸãªã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã¨ã—ã¦ã€MicrosoftãŒæŽ¡ç”¨ã‚’æ¤œè¨Žã—ã¦ã„ã‚‹ã¨ã„ã†è©±ã‚‚ã‚ã‚Šã¾ã™ã€‚ Excelã«Pythonæè¼‰ã€ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆãŒæ¤œè¨Žã€‚ã‚¢ãƒ³ã‚±ãƒ¼ãƒˆã‚’å®Ÿæ–½ä¸ ã¾ãšPandasã®å…¨ä½“åƒã‚’æŽ´ã‚“ã§ã¿ã‚‹ Pand
icica 2019/03/18
ã‚ã¨ã§èªã‚€

python

pandas
ãƒªãƒ³ã‚¯
pandas.DataFrameã®è¡Œã‚’æ¡ä»¶ã§æŠ½å‡ºã™ã‚‹query | note.nkmk.me
pandas.DataFrameã‹ã‚‰ä»»æ„ã®æ¡ä»¶ã‚’æº€ãŸã™è¡Œã‚’æŠ½å‡ºã™ã‚‹ã«ã¯query()ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã†ã€‚æ¯”è¼ƒæ¼”ç®—åã‚„æ–‡å—åˆ—ãƒ¡ã‚½ãƒƒãƒ‰ã«ã‚ˆã‚‹æ¡ä»¶æŒ‡å®šã€è¤‡æ•°æ¡ä»¶ã®çµ„ã¿åˆã‚ã›ãªã©ã‚’ç°¡æ½”ã«è¨˜è¿°ã§ãã‚‹ã€‚ pandas.DataFrame.query â€” pandas 2.1.4 documentation Indexing and selecting data - The query() Method â€” pandas 2.1.4 documentation ãƒ–ãƒ¼ãƒªã‚¢ãƒ³ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆBoolean indexingï¼‰ã«ã‚ˆã‚‹æ¡ä»¶æŒ‡å®šã«ã¤ã„ã¦ã¯ä»¥ä¸‹ã®è¨˜äº‹ã‚’å‚ç…§ã€‚ é–¢é€£è¨˜äº‹: pandasã§è¤‡æ•°æ¡ä»¶ã®AND, OR, NOTã‹ã‚‰è¡Œã‚’æŠ½å‡ºï¼ˆé¸æŠžï¼‰ ç‰¹å®šã®åž‹ã®åˆ—ã‚’æŠ½å‡ºã—ãŸã‚Šã€è¡Œåãƒ»åˆ—åã§è¡Œãƒ»åˆ—ã‚’æŠ½å‡ºã—ãŸã‚Šã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ é–¢é€£è¨˜äº‹: pandas.DataFrameã‹ã‚‰ç‰¹å®šã®åž‹ã®åˆ—ã‚’æŠ½å‡ºãƒ»é™¤å¤–ã™ã‚‹select_dt
icica 2019/02/21
pandas

python
ãƒªãƒ³ã‚¯
pandasã§è¤‡æ•°æ¡ä»¶ã®AND, OR, NOTã‹ã‚‰è¡Œã‚’æŠ½å‡ºï¼ˆé¸æŠžï¼‰ | note.nkmk.me
pandasã§è¤‡æ•°ã®æ¡ä»¶ã®AND, OR, NOTã‹ã‚‰pandas.DataFrameã®è¡Œã‚’æŠ½å‡ºã™ã‚‹æ–¹æ³•ã‚’èª¬æ˜Žã™ã‚‹ã€‚ æ³¨æ„ç‚¹ã¯äºŒã¤ã€‚ &ã€|ã€~ã‚’ä½¿ã†ï¼ˆandã€orã€notã ã¨ã‚¨ãƒ©ãƒ¼ï¼‰ æ¯”è¼ƒæ¼”ç®—åã‚’ä½¿ã†ã¨ãã¯æ¡ä»¶ã”ã¨ã«æ‹¬å¼§ã§å›²ã‚€ï¼ˆæ‹¬å¼§ãŒãªã„ã¨ã‚¨ãƒ©ãƒ¼ï¼‰ ãªãŠã€ã“ã“ã§ã¯ãƒ–ãƒ¼ãƒªã‚¢ãƒ³ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆBoolean indexingï¼‰ã‚’ç”¨ã„ãŸæ–¹æ³•ã‚’èª¬æ˜Žã™ã‚‹ãŒã€query()ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã†ã¨ã‚ˆã‚Šç°¡æ½”ã«æ›¸ã‘ã‚‹ã€‚ é–¢é€£è¨˜äº‹: pandas.DataFrameã®è¡Œã‚’æ¡ä»¶ã§æŠ½å‡ºã™ã‚‹query æœ¬è¨˜äº‹ã®ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã®pandasã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ä»¥ä¸‹ã®pandas.DataFrameã‚’ä¾‹ã¨ã—ã¦ä½¿ã†ã€‚ sample_pandas_normal.csv import pandas as pd print(pd.__version__) # 2.0.3 df = pd.read_csv('data/src/s
icica 2019/02/21
pandas

python
ãƒªãƒ³ã‚¯
pandasã§1000ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã®å‰å‡¦ç†ã‚’é«˜é€Ÿã«ã™ã‚‹Tipsé›† - Qiita
ã¯ã˜ã‚ã« å½“ç¤¾ã«ã‚¢ãƒ«ãƒã‚¤ãƒˆã«æ¥ã¦ã„ãŸäººï¼ˆæ¥æ˜¥ã«æ–°å’å…¥ç¤¾ã®äºˆå®šï¼‰ã«ã€Œpandasã‚’é«˜é€ŸåŒ–ã™ã‚‹ãŸã‚ã®æƒ…å ±ã¯ç„¡ã„ã§ã™ã‹ï¼Ÿã€ã¨å°‹ãã‚‰ã‚Œã¾ã—ãŸã€‚ ã“ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ä½¿ã„æ–¹ã¯å¤šæ•°ã®æ›¸ç±ã‚„Webã§ä½“ç³»ç«‹ã£ãŸè¨˜äº‹ã§æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ã€é«˜é€ŸåŒ–ã«é–¢ã—ã¦ã¯ä½“ç³»çš„ãªæƒ…å ±æºãŒæ€ã„ã¤ã‹ãªã‹ã£ãŸã®ã§ã€ã€Œå®Ÿéš›ã«æ›¸ã„ã¦ã¿ã¦ã€1ã¤1ã¤ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã—ã‹ãªã„ã§ã™ã€ã¨ã—ã‹ç”ãˆã‚‰ã‚Œã¾ã›ã‚“ã§ã—ãŸã€‚ ãã“ã§ã€ã“ã®æ–¹ã‚’å§‹ã‚ã€æ¥æ˜¥ï¼ˆ2019å¹´4æœˆï¼‰ã«ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒŠãƒªã‚¹ãƒˆã¾ãŸã¯ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆã«ãªã‚‹æ–°å’ã¸å‘ã‘ã¦ã€pandasã®é«˜é€ŸåŒ–ã«é–¢ã™ã‚‹ç§ã®çµŒé¨“ã‚’Tipsé›†ã«ã—ã¦ãŠä¼ãˆã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã¯ä»Šå¾Œã‚‚å†…å®¹ã‚’å……å®Ÿã•ã›ã‚‹ãŸã‚ã«ã€Tipsã‚’è¿½åŠ ã—ã¦ã„ãã¾ã™ã€‚ ã“ã®è¨˜äº‹ã‚’èªã‚“ã å¾Œã«ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ pandasã§ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°1000ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã§ã‚‚1åˆ†ä»¥å†…ã§å®Œäº†ã™ã‚‹å‰å‡¦ç†ãŒæ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ãã®çµæžœã€1æ—¥ä¸å®Ÿè¡Œã—ç¶šã‘ãªã‘ã‚Œã°ãª
icica 2018/12/25
ã‚ã¨ã§èªã‚€

pandas

python
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿åˆ†æžã§é »å‡ºã®PandasåŸºæœ¬æ“ä½œ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã¯ã˜ã‚ã« æ©Ÿæ¢°å¦ç¿’ã‚„æ·±å±¤å¦ç¿’ãŒäººæ°—ã®æ˜¨ä»Šã§ã™ãŒã€ãã‚Œã‚‰ã®ãƒ¢ãƒ‡ãƒ«ã®ç²¾åº¦ã«æœ€ã‚‚ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ã«å½±éŸ¿ã™ã‚‹ã®ã¯ã‚¤ãƒ³ãƒ—ãƒƒãƒˆã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®è³ªã§ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã®è³ªã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’é©åˆ‡ã«æŠŠæ¡ã—ã€ä¸è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’å–ã‚Šé™¤ã„ãŸã‚Šã€å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’ç²¾æŸ»ã™ã‚‹å‰å‡¦ç†ã‚’è¡Œã†ã“ã¨ã§é«˜ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ æœ¬é ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®åŸºæœ¬ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦Pandasã®ä½¿ã„æ–¹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚Pandasã«ã¯ä¾¿åˆ©ãªæ©Ÿèƒ½ãŒãŸãã•ã‚“ã‚ã‚Šã¾ã™ãŒã€ç‰¹ã«åˆ†æžæ¥å‹™ã§é »å‡ºã®Pandasé–¢æ•°ãƒ»ãƒ¡ã‚½ãƒƒãƒ‰ã‚’é‡ç‚¹çš„ã«å–ã‚Šä¸Šã’ã¾ã—ãŸã€‚ Pandasã«ä¾¿åˆ©ãªãƒ¡ã‚½ãƒƒãƒ‰ãŒãŸãã•ã‚“ã‚ã‚‹ã“ã¨ã¯çŸ¥ã£ã¦ã„ã‚‹ã€ã§ã‚‚ãƒ¯ã‚¤ãŒçŸ¥ã‚ŠãŸã„ã®ã¯åˆ†æžã«æœ€
icica 2018/10/11
ãƒ‡ãƒ¼ã‚¿

åˆ†æž

åŸºæœ¬

python

Pandas
ãƒªãƒ³ã‚¯
1