Pandas-ai: ChatGPT テクノロジーを統合した、インタラクティブなデータ処理の新しい方法。

<code>import pandas as pd from pandasai import PandasAI  # Sample DataFrame df = pd.DataFrame({ "country": ["United States", "United Kingdom", "France", "Germany", "Italy", "Spain", "Canada", "Australia", "Japan", "China"], "gdp": [21400000, 2940000, 2830000, 3870000, 2160000, 1350000, 1780000, 1320000, 516000, 14000000], "happiness_index": [7.3, 7.2, 6.5, 7.0, 6.0, 6.3, 7.3, 7.3, 5.9, 5.0] })  # Instantiate a LLM from pandasai.llm.openai import OpenAI llm = OpenAI()  pandas_ai = PandasAI(llm) pandas_ai.run(df, prompt='Which are the 5 happiest countries?')</code>

<code>pandas_ai.run( df, "Plot the histogram of countries showing for each the gpd, using different colors for each bar", )</code>

<code>pip install pandasai</code>

<code>#Import pandas and pandas-ai import pandas as pd from pandasai import PandasAI # Instantiating my llm using OpenAI API key. from pandasai.llm.openai import OpenAI # OpenAI llm = OpenAI(api_token="YOUR_OPENAI_API_KEY")</code>

<code># creating the uri and connecting to database pg_conn = "postgresql://YOUR URI HERE"  #Query sql database query = """ SELECT * FROM table_name """  #Create dataframe named df df = pd.read_sql(query,pg_conn)</code>

<code># Using pandas-ai! pandas_ai = PandasAI(llm) pandas_ai.run(df, prompt='Place your prompt here)</code>