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

deejayroka id:deejayroka

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

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

Pandasã‹ã‚‰Polarsã¸ç§»è¡Œã—ãŸæ–¹ãŒã„ã„ã®ã‹ - Qiita
ãªãœã“ã®è¨˜äº‹ã‚’æ›¸ãã®ã‹ çš†ã•ã‚“ã€ãƒ‡ãƒ¼ã‚¿è§£æžã‚’è¡Œã†éš›ã«ã©ã®ã‚ˆã†ãªãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ç”¨ã„ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ ãŠãã‚‰ãå¤§åŠã®äººã¯pandasã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ç§ã‚‚pandasä½¿ã£ã¦ã¾ã™ã€‚ç°¡å˜ã ã‚ˆã(Â´ãƒ»Ï‰ãƒ»ï½€) ã—ã‹ã—ã€æ¥å‹™ã§ãƒã‚«ã‚¯ã‚½ã§ã‘ãˆãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã‚‚ã†ã¨ã—ãŸã¨ãã«ã€èªã¿è¾¼ã¿æ™‚é–“ãŒã¨ã‚“ã§ã‚‚ãªãã‹ã‹ã£ãŸã‚Šã€ãƒ¡ãƒ¢ãƒªä¸è¶³ã§ãã‚‚ãã‚‚èªã¿è¾¼ã‚ã‚‚ã—ãªã„ã“ã¨ãŒèµ·ãã¦ã„ã¾ã—ãŸã€‚ èªã¿è¾¼ã¿ã«ãƒ¡ãƒ¢ãƒªé£Ÿã‚ã‚Œã™ãŽã¦ä»–ã®ä½œæ¥ãŒã§ããšã«å¾…æ©Ÿã—ãŸæŒ™å¥ã€ç‡ƒãˆå°½ããŸã‹ã®ã‚ˆã†ã«ãƒŽãƒ¼ãƒ‘ã‚½ã®ãƒ•ã‚¡ãƒ³ãŒæ¢ã¾ã‚‹ã¨åŒæ™‚ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã®ã‚¨ãƒ©ãƒ¼ãŒå‡ºãŸã¨ãã«ã¯åˆ‡ã‚Œæ•£ã‚‰ã‹ã—ã¾ã™ã€‚ ï¼ˆç”»åƒå…ƒï¼šè‘¬é€ã®ãƒ•ãƒªãƒ¼ãƒ¬ãƒ³å…¬å¼Xã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒã‚¹ãƒˆã‚ˆã‚Šï¼‰ ãã‚“ãªã“ã¨ã‚‚ã‚ã‚Šã€AWSãªã©ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã§ãƒ¡ãƒ¢ãƒªã«ä½™è£•ã‚’æŒãŸã›ã‚‹ãŸã‚ã«ã‚ã¡ã‚ƒãã¡ã‚ƒè‰¯ã„ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã—ãŸãŒã€ã‚³ã‚¹ãƒˆã®å•é¡Œã§æ–å¿µã—ã¾ã—ãŸã€‚ ã—ã‹ã—ã€ã©ã†ã—ã¦ã‚‚èªã¿è¾¼ã¿ãŸã„ã¨ã„ã†ã“ã¨ã‚‚ã‚ã‚Š
deejayroka 2024/04/19
â€œPolrasç‰¹æœ‰ã®æ›¸ãæ–¹ã«æ…£ã‚Œã‚‹å¿…è¦ãŒã‚ã‚‹ æ¬ æå€¤ã®èªã¿è¾¼ã¿æ–¹ãªã©ãŒé¢å€’ ãã‚‰ã„ã§ã™ã‹ãã€‚â€

pandas

qiita

ãƒ©ã‚¤ãƒ–ãƒ©ãƒª
ãƒªãƒ³ã‚¯
Azure OpenAI + Jupyter Notebookã§è‡ªå®¶è£½Code Interpreterã‚’å®Ÿç¾ã™ã‚‹ - Qiita
ã¯ã˜ã‚ã« ChatGPT Code Interpreter ã„ã„ã§ã™ã‚ˆãã€‚ã§ã‚‚Azure OpenAIã§ã¯ã¾ã ã¾ã ä½¿ãˆãªã•ãã†(ãã‚‚ãã‚‚ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚‹ã®ã‹ï¼Ÿ)ãªã®ã§ã€Jupyter Notebookã¨çµ„ã¿åˆã‚ã›ã¦åŒã˜ã‚ˆã†ãªã“ã¨ã‚’å®Ÿç¾ã—ã¦ã¿ã¾ã—ãŸã€‚ Function CallingãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Œã°ã€ã¡ã‚‡ã£ã¨å®Ÿè£…ã‚’å¤‰ãˆãŸã»ã†ãŒã‚ˆã„ã¨ã“ã‚ã‚‚ã‚ã‚Šã¾ã™ãŒã€ã¨ã‚Šã‚ãˆãšç”ŸChatGPTã§é€²ã‚ã¾ã™ã€‚gpt-35-turbo(0613)ã§ã™ã€‚ãŠå®‰ãã§ãã¾ã™ãã€‚ ç’°å¢ƒæº–å‚™ Jupyter Notebookã‚’ä½¿ãˆã‚‹ç’°å¢ƒã¯ãŠå¥½ã¿ã®æ–¹æ³•ã§ã”ç”¨æ„ãã ã•ã„ã€‚ ã‚ã¨ã€openaiã€matplotlib, pandas, numpyã¨ã‹å¿…è¦ãªã‚‚ã®ã‚‚ãŠå¥½ããªç’°å¢ƒã«ã©ã†ãžã€‚ãªãŠã€æ—¥æœ¬èªžã§ã‚°ãƒ©ãƒ•ã‚’ä½œæˆã—ãŸã„ã®ã§ã€japanize-matplotlibã¯ã„ã‚Œã¦ãŠã„ã¦ãã ã•ã„ã€‚ Code Interpreterã‚’å®Ÿç¾ã™ã‚‹é–¢æ•°
deejayroka 2023/09/03
openai

Azure

pandas

ChatGPT
ãƒªãƒ³ã‚¯
Googleè£½å¯è¦–åŒ–OSSã®FacetsãŒã‚ã£ã¡ã‚ƒä¾¿åˆ©ã ã‹ã‚‰ä½¿ã£ã¦ã¿ã¦ãã‚Œ - Qiita
Help us understand the probl em. What is going on with this article?
deejayroka 2017/09/28
ãƒ„ãƒ¼ãƒ«

pandas

google

ãƒ‡ãƒ¼ã‚¿
ãƒªãƒ³ã‚¯
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?
deejayroka 2017/08/18
pandas

python

ãƒ‡ãƒ¼ã‚¿

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
10åˆ†ã§Pandasã‚’å¦ã¶ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
deejayroka 2017/08/18
dataframe

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

pandas

python
ãƒªãƒ³ã‚¯
pandasã§tableã‚’ç°¡å˜ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚° - Qiita
ã“ã‚“ãªã‚µã‚¤ãƒˆã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’pandasã®ãƒ‡ãƒ¼ã‚¿ãƒ•ãƒ¬ãƒ¼ãƒ ã«å–ã‚Šè¾¼ã¿ãŸãã¦ã€BeautifulSoupã®ã‚¿ã‚°ã‹ã‚‰ãƒªã‚¹ãƒˆã«å¤‰æ›ã—ã¦ãƒ»ãƒ»ãƒ»ã¨è‰²ã€…ã‚„ã£ã¦ã„ãŸãã“ã®ã‚ãªãŸï¼ ãªã‚“ã¨ã€read_html(flavor='bs4')ã ã‘ã§ç°¡å˜ã«æŒã£ã¦ãã‚‹ã“ã¨ãŒã§ãã¾ã™ã‚ˆã€‚ (ãˆï¼ŸçŸ¥ã£ã¦ãŸï¼Ÿãƒ»ãƒ»ãƒ»è‡ªåˆ†ã¯çŸ¥ã‚‰ãªãã¦ãšã£ã¨æã—ã¦ã¾ã—ãŸorz) import pandas as pd tables = pd.read_html('http://stocks.finance.yahoo.co.jp/stocks/history/?code=998407.O', flavor='bs4') print(tables[1]) """ 0 1 2 3 4 0 æ—¥ä»˜ å§‹å€¤ é«˜å€¤ å®‰å€¤ çµ‚å€¤ 1 2015å¹´11æœˆ19æ—¥ 19851.24 19959.06 19761.56 19859.81 2 2015å¹´11æœˆ18æ—¥ 1977
deejayroka 2017/08/18
pandas

2015å¹´

ã‚¹ã‚¯ãƒ¬ã‚¤ãƒ”ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆãƒ»ãƒ‡ãƒ¼ã‚¿ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã® Python ãƒ©ã‚¤ãƒ–ãƒ©ãƒªä¸€è¦§ - Qiita
ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚„ãƒ‡ãƒ¼ã‚¿åŠ å·¥ã€æ©Ÿæ¢°å¦ç¿’ãªã©ã‚’è¡Œã†ã®ã«ä¾¿åˆ©ãª Python ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ç´¹ä»‹ã™ã‚‹ã€‚ ãªãœ Python ãªã®ã‹ çµ±è¨ˆã‚„æ©Ÿæ¢°å¦ç¿’ã‚’ã™ã‚‹ãªã‚‰ã€ R ã¨ã„ã†é¸æŠžè‚¢ã‚‚ã‚ã‚‹ã€‚ R ã®ãƒ‡ãƒ¼ã‚¿ã®åŠ å·¥ã‚„é›†è¨ˆã€çµ±è¨ˆå‡¦ç†ã«å„ªã‚ŒãŸè¨€èªžã§ã‚ã‚Šã€è¨€èªžæ¨™æº–ã®æ©Ÿèƒ½ã ã‘ã§ã‹ãªã‚Šã®ã“ã¨ãŒã§ãã‚‹ã€‚æ©Ÿæ¢°å¦ç¿’ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚‚å……å®Ÿã—ã¦ãŠã‚Šã€æœ‰åŠ›ãªé¸æŠžè‚¢ã§ã‚ã‚‹ã“ã¨ã¯é–“é•ã„ãªã„ã€‚ R ã¨æ¯”è¼ƒã—ã¦ Python ãŒå„ªã‚Œã¦ã„ã‚‹ç‚¹ã¯ã€å‘¨è¾ºã‚¨ã‚³ã‚·ã‚¹ãƒ†ãƒ ã®å……å®Ÿã«ã‚ã‚‹ã€‚ Python ã‚¨ã‚³ã‚·ã‚¹ãƒ†ãƒ ã¯ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ã‚¹ã®åˆ†é‡Žã«ç•™ã¾ã‚‰ãªã„ã€‚ NumPy ã‚„ Pands ã§åŠ å·¥ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ Django ã‚’ä½¿ã£ãŸæœ¬æ ¼çš„ãª Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§åˆ©ç”¨ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã ã€‚ ãƒ©ã‚¤ãƒ–ãƒ©ãƒªç¾¤ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã“ã“ã§æŒ™ã’ã¦ã„ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®ã»ã¨ã‚“ã©ã¯ Anaconda ã§ä¸€æ‹¬ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿åŠ å·¥ NumPy NumPy ã¯æ•°å€¤è¨ˆç®—ã‚’åŠ¹çŽ‡çš„ã«è¡Œã†ãŸã‚
deejayroka 2017/08/02
numpy

ãƒ‡ãƒ¼ã‚¿

pandas

python
ãƒªãƒ³ã‚¯
pandas ã® locã€ilocã€ix ã®é•ã„ â€“ python | ã‚³ãƒ¼ãƒ‰ï¼—åŒº
from pandas import DataFrame df=DataFrame([[1,2,3], [10,20,30], [100,200,300], [1000,2000,3000]], index=['row_0', 'row_1','row_2','row_3'], columns=['col_0','col_1','col_2']) #----------------------------- # col_0 col_1 col_2 # row_0 1 2 3 # row_1 10 20 30 # row_2 100 200 300 # row_3 1000 2000 3000 #----------------------------- # # è¡Œãƒ©ãƒ™ãƒ«ã‚’æŒ‡å®š # df.loc[['row_2','row_3']] #----------------------------
deejayroka 2017/07/19
ã‚ã¨ã§èªã‚€

ãƒ‡ãƒ¼ã‚¿

pandas

dataframe

iloc

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

ã‚¹ãƒ©ã‚¤ã‚¹

Python

ix
ãƒªãƒ³ã‚¯
æ©Ÿæ¢°å¦ç¿’ã®ãŸã‚ã®Python/NumPy/pandasãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ï¼ˆãƒ‘ãƒ¼ãƒˆ2ï¼‰ - ã‚ã‚‚ã‚ã‚‚
â€»ãƒ‘ãƒ¼ãƒˆ1ã¯ã€ã“ã¡ã‚‰ã§ã™ã€‚ DataFrameã¨ã¯ï¼Ÿ ãƒ‘ãƒ¼ãƒˆ2ã§ã¯ã€pandasã®DataFrameã‚’èª¬æ˜Žã—ã¾ã™ã€‚ã“ã‚Œã¯ã€ã‚¨ã‚¯ã‚»ãƒ«ã‚·ãƒ¼ãƒˆã®ã‚ˆã†ã«ã€ç¸¦æ¨ªã«ä¸¦ã¹ãŸãƒ‡ãƒ¼ã‚¿ã«ãƒ©ãƒ™ãƒ«ã‚’ã¤ã‘ã¦å–ã‚Šæ‰±ã†ã“ã¨ãŒã§ãã¾ã™ã€‚Rè¨€èªžã®ãƒ‡ãƒ¼ã‚¿ãƒ•ãƒ¬ãƒ¼ãƒ ã«ç›¸å½“ã™ã‚‹ã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ Seriesã¨DataFrame DataFrameã¯ã€RDBã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ˆã†ã«ã€1ã¤ã®åˆ—ãŒç‰¹å®šã®ãƒ‡ãƒ¼ã‚¿é …ç›®ã€ï¼‘ã¤ã®è¡ŒãŒï¼‘ã¤ã®ãƒ‡ãƒ¼ã‚¿ï¼ˆãƒ¬ã‚³ãƒ¼ãƒ‰ï¼‰ã‚’è¡¨ã—ã¾ã™ã€‚ï¼‘ã¤ã®åˆ—ã€ã‚‚ã—ãã¯ã€ï¼‘ã¤ã®è¡Œã‚’å–ã‚Šå‡ºã—ãŸã‚‚ã®ãŒSeriesã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã§ã™ã€‚ ã¾ãšã€ç‰¹å®šã®ãƒ‡ãƒ¼ã‚¿é …ç›®ã«å¯¾å¿œã™ã‚‹Seriesã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œã£ã¦ã¿ã¾ã™ã€‚ãã‚Œãžã‚Œã€éƒ½å¸‚åã€æ°—æ¸©ã€æ¹¿åº¦ã‚’è¡¨ã™ãƒ‡ãƒ¼ã‚¿ã§ã™ã€‚ In [1]: city = Series(['Tokyo','Osaka','Nagoya','Okinawa'], name='City') In [2]: temp = Series([
deejayroka 2017/07/19
ã‚ã¨ã§èªã‚€

ãƒ‡ãƒ¼ã‚¿

ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ

pandas

ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«

numpy

æ©Ÿæ¢°å¦ç¿’

Python
ãƒªãƒ³ã‚¯
pandasã§ä½¿ã‚ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ï½ž1æ¬¡å…ƒã€2æ¬¡å…ƒã€3æ¬¡å…ƒã®ãƒ‡ãƒ¼ã‚¿ã®æ‰±ã„æ–¹ï½ž - ä»Šæ—¥ã‚‚çª“è¾ºã§ãƒ—ãƒã‚°ãƒ©ãƒ
ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ ä»Šã¾ã§ãªã‚“ã¨ãªãã§ä½¿ç”¨ã—ã¦ã„ãŸpandasã§ã™ãŒã€ãªã‚“ã¨ãªãã§å®Ÿè£…ã—ã¦ã„ãŸã‚³ãƒ¼ãƒ‰ï¼ˆæ—¥çµŒå¹³å‡äºˆæƒ³ã®ã‚„ã¤ã§ã™ï¼‰ãŒæ±šããƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãŒé›£ã—ããªã£ã¦ããŸã®ã§ã€ä¸€åº¦ã¡ã‚ƒã‚“ã¨pandasã§ã®ãƒ‡ãƒ¼ã‚¿ã®æ‰±ã„æ–¹ã‚’ã¾ã¨ã‚ã¦ãŠã“ã†ã¨æ€ã£ã¦æ›¸ã„ãŸã‚‚ã®ã§ã™ã€‚ pandasã®å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã« Intro to Data Structures ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã€åŸºæœ¬çš„ã«ã¯ãã“ã§èª¬æ˜Žã•ã‚Œã¦ã„ã‚‹ã“ã¨ã®ä¸€éƒ¨ã‚’ãƒ”ãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¦ç´¹ä»‹ã—ã¦ã„ã‚‹è¨˜äº‹ã«ãªã‚Šã¾ã™ã€‚ http://pandas.pydata.org/pandas-docs/stable/dsintro.html ç›®æ¬¡ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ ç›®æ¬¡ Series: 1æ¬¡å…ƒã®ãƒ‡ãƒ¼ã‚¿ Seriesã®ä½œã‚Šæ–¹ Seriesã¯numpyã®ndarrayã«ä¼¼ã¦ã„ã‚‹ Seriesã¯Pythonã®è¾žæ›¸ã«ä¼¼ã¦ã„ã‚‹ ãƒ™ã‚¯ãƒˆãƒ«çš„ãªè¨ˆç®—ã‚‚ã§ãã¾ã™ Nameå±žæ€§ DataFrame: 2
deejayroka 2017/07/13
ãƒ‡ãƒ¼ã‚¿

Python

pandas

numpy
ãƒªãƒ³ã‚¯
1