Konverter CSV - Anthropic

Salin prompt ini ke Console pengembang kami untuk mencobanya sendiri!

	Konten
System	Sebagai ahli konversi data, tugas Anda adalah mengonversi data dari berbagai format (JSON, XML, dll.) menjadi file CSV yang diformat dengan benar. Pengguna akan memberikan data input dalam format aslinya, beserta persyaratan atau preferensi khusus untuk output CSV (misalnya, urutan kolom, pembatas, pengkodean). Pastikan Anda memiliki pemahaman yang jelas tentang struktur data dan format CSV yang diinginkan, ajukan pertanyaan klarifikasi jika diperlukan. Setelah Anda memiliki informasi yang diperlukan, hasilkan output CSV dengan mengikuti aturan pemformatan yang sesuai, seperti menggunakan koma sebagai pembatas, menempatkan nilai dalam tanda kutip jika diperlukan, dan menangani karakter khusus atau jeda baris dengan benar. Terakhir, berikan instruksi atau tips tambahan untuk menyimpan atau menggunakan file CSV.
User	Tolong konversikan data JSON berikut menjadi file CSV: [ { “name”: “John Doe”, “age”: 30, “city”: “New York”, “email”: “john.doe@example.com” }, { “name”: “Jane Smith”, “age”: 25, “city”: “London”, “email”: “jane.smith@example.com” }, { “name”: “Bob Johnson”, “age”: 35, “city”: “Paris”, “email”: “bob.johnson@example.com” } ] Persyaratan: - Kolom dalam CSV harus dalam urutan: name, age, city, email - Gunakan titik koma (;) sebagai pembatas - Tempatkan semua nilai dalam tanda kutip ganda (“)

Konten

System

Sebagai ahli konversi data, tugas Anda adalah mengonversi data dari berbagai format (JSON, XML, dll.) menjadi file CSV yang diformat dengan benar. Pengguna akan memberikan data input dalam format aslinya, beserta persyaratan atau preferensi khusus untuk output CSV (misalnya, urutan kolom, pembatas, pengkodean). Pastikan Anda memiliki pemahaman yang jelas tentang struktur data dan format CSV yang diinginkan, ajukan pertanyaan klarifikasi jika diperlukan. Setelah Anda memiliki informasi yang diperlukan, hasilkan output CSV dengan mengikuti aturan pemformatan yang sesuai, seperti menggunakan koma sebagai pembatas, menempatkan nilai dalam tanda kutip jika diperlukan, dan menangani karakter khusus atau jeda baris dengan benar. Terakhir, berikan instruksi atau tips tambahan untuk menyimpan atau menggunakan file CSV.

User

Tolong konversikan data JSON berikut menjadi file CSV:

[
{
“name”: “John Doe”,
“age”: 30,
“city”: “New York”,
“email”: “john.doe@example.com”
},
{
“name”: “Jane Smith”,
“age”: 25,
“city”: “London”,
“email”: “jane.smith@example.com”
},
{
“name”: “Bob Johnson”,
“age”: 35,
“city”: “Paris”,
“email”: “bob.johnson@example.com”
}
]
Persyaratan:
- Kolom dalam CSV harus dalam urutan: name, age, city, email
- Gunakan titik koma (;) sebagai pembatas
- Tempatkan semua nilai dalam tanda kutip ganda (“)

Contoh Output

Berdasarkan data JSON yang diberikan dan persyaratan, berikut adalah file CSV yang dikonversi:

csv
"name";"age";"city";"email"
"John Doe";"30";"New York";"john.doe@example.com"
"Jane Smith";"25";"London";"jane.smith@example.com"
"Bob Johnson";"35";"Paris";"bob.johnson@example.com"

Penjelasan:

Baris pertama file CSV berisi header kolom: “name”, “age”, “city”, dan “email”, dipisahkan oleh titik koma (;) dan ditempatkan dalam tanda kutip ganda (”).
Setiap baris berikutnya mewakili baris data, dengan nilai yang dipisahkan oleh titik koma (;) dan ditempatkan dalam tanda kutip ganda (”).
Urutan nilai dalam setiap baris sesuai dengan urutan kolom yang ditentukan: name, age, city, dan email.
Karakter khusus, jika ada dalam nilai, dipertahankan dalam tanda kutip ganda.

Untuk menyimpan file CSV:

Salin data CSV yang diberikan di atas.
Buka editor teks (misalnya, Notepad, TextEdit, atau editor teks biasa lainnya).
Tempel data CSV ke dalam editor teks.
Simpan file dengan ekstensi .csv (misalnya, data.csv).

Catatan: Saat membuka file CSV di aplikasi spreadsheet (misalnya, Microsoft Excel, Google Sheets), pastikan untuk menentukan pembatas yang benar (titik koma) dan keberadaan tanda kutip ganda di sekitar nilai untuk memastikan pemformatan yang tepat.

Permintaan API

import anthropic

client = anthropic.Anthropic(  # defaults to os.environ.get("ANTHROPIC_API_KEY")
    api_key="my_api_key",
)
message = client.messages.create(
    model="claude-opus-4-20250514",
    max_tokens=1000,
    temperature=0,
    system="As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.",
    messages=[
        {
            "role": "user",
            "content": [
                {
                    "type": "text",
                    "text": 'Please convert the following JSON data into a CSV file: \n \n[ \n { \n "name": "John Doe", \n "age": 30, \n "city": "New York", \n "email": "[email protected]" \n }, \n { \n "name": "Jane Smith", \n "age": 25, \n "city": "London", \n "email": "[email protected]" \n }, \n { \n "name": "Bob Johnson", \n "age": 35, \n "city": "Paris", \n "email": "[email protected]" \n } \n] \n \nRequirements: \n- Columns in the CSV should be in the order: name, age, city, email \n- Use semicolons (;) as delimiters \n- Enclose all values in double quotes (")',
                }
            ],
        }
    ],
)
print(message.content)

import anthropic

client = anthropic.Anthropic(  # defaults to os.environ.get("ANTHROPIC_API_KEY")
    api_key="my_api_key",
)
message = client.messages.create(
    model="claude-opus-4-20250514",
    max_tokens=1000,
    temperature=0,
    system="As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.",
    messages=[
        {
            "role": "user",
            "content": [
                {
                    "type": "text",
                    "text": 'Please convert the following JSON data into a CSV file: \n \n[ \n { \n "name": "John Doe", \n "age": 30, \n "city": "New York", \n "email": "[email protected]" \n }, \n { \n "name": "Jane Smith", \n "age": 25, \n "city": "London", \n "email": "[email protected]" \n }, \n { \n "name": "Bob Johnson", \n "age": 35, \n "city": "Paris", \n "email": "[email protected]" \n } \n] \n \nRequirements: \n- Columns in the CSV should be in the order: name, age, city, email \n- Use semicolons (;) as delimiters \n- Enclose all values in double quotes (")',
                }
            ],
        }
    ],
)
print(message.content)

import Anthropic from "@anthropic-ai/sdk";

const anthropic = new Anthropic({
  apiKey: "my_api_key", // defaults to process.env["ANTHROPIC_API_KEY"]
});

const msg = await anthropic.messages.create({
  model: "claude-opus-4-20250514",
  max_tokens: 1000,
  temperature: 0,
  system: "As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.",
  messages: [
    {
      "role": "user",
      "content": [
        {
          "type": "text",
          "text": "Please convert the following JSON data into a CSV file:  \n  \n[  \n  {  \n    \"name\": \"John Doe\",  \n    \"age\": 30,  \n    \"city\": \"New York\",  \n    \"email\": \"[email protected]\"  \n  },  \n  {  \n    \"name\": \"Jane Smith\",  \n    \"age\": 25,  \n    \"city\": \"London\",  \n    \"email\": \"[email protected]\"  \n  },  \n  {  \n    \"name\": \"Bob Johnson\",  \n    \"age\": 35,  \n    \"city\": \"Paris\",  \n    \"email\": \"[email protected]\"  \n  }  \n]  \n  \nRequirements:  \n- Columns in the CSV should be in the order: name, age, city, email  \n- Use semicolons (;) as delimiters  \n- Enclose all values in double quotes (\")"
        }
      ]
    }
  ]
});
console.log(msg);

from anthropic import AnthropicBedrock

# See https://docs.anthropic.com/claude/reference/claude-on-amazon-bedrock

# for authentication options

client = AnthropicBedrock()

message = client.messages.create(
model="anthropic.claude-opus-4-20250514-v1:0",
max_tokens=1000,
temperature=0,
system="As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.",
messages=[
{
"role": "user",
"content": [
{
"type": "text",
"text": "Please convert the following JSON data into a CSV file: \n \n[ \n { \n \"name\": \"John Doe\", \n \"age\": 30, \n \"city\": \"New York\", \n \"email\": \"[email protected]\" \n }, \n { \n \"name\": \"Jane Smith\", \n \"age\": 25, \n \"city\": \"London\", \n \"email\": \"[email protected]\" \n }, \n { \n \"name\": \"Bob Johnson\", \n \"age\": 35, \n \"city\": \"Paris\", \n \"email\": \"[email protected]\" \n } \n] \n \nRequirements: \n- Columns in the CSV should be in the order: name, age, city, email \n- Use semicolons (;) as delimiters \n- Enclose all values in double quotes (\")"
}
]
}
]
)
print(message.content)

import AnthropicBedrock from "@anthropic-ai/bedrock-sdk";

// See https://docs.anthropic.com/claude/reference/claude-on-amazon-bedrock
// for authentication options
const client = new AnthropicBedrock();

const msg = await client.messages.create({
  model: "anthropic.claude-opus-4-20250514-v1:0",
  max_tokens: 1000,
  temperature: 0,
  system: "As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.",
  messages: [
    {
      "role": "user",
      "content": [
        {
          "type": "text",
          "text": "Please convert the following JSON data into a CSV file:  \n  \n[  \n  {  \n    \"name\": \"John Doe\",  \n    \"age\": 30,  \n    \"city\": \"New York\",  \n    \"email\": \"[email protected]\"  \n  },  \n  {  \n    \"name\": \"Jane Smith\",  \n    \"age\": 25,  \n    \"city\": \"London\",  \n    \"email\": \"[email protected]\"  \n  },  \n  {  \n    \"name\": \"Bob Johnson\",  \n    \"age\": 35,  \n    \"city\": \"Paris\",  \n    \"email\": \"[email protected]\"  \n  }  \n]  \n  \nRequirements:  \n- Columns in the CSV should be in the order: name, age, city, email  \n- Use semicolons (;) as delimiters  \n- Enclose all values in double quotes (\")"
        }
      ]
    }
  ]
});
console.log(msg);

from anthropic import AnthropicVertex

client = AnthropicVertex()

message = client.messages.create(
    model="claude-3-sonnet@20240229",
    max_tokens=1000,
    temperature=0,
    system="As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.",
    messages=[
        {
            "role": "user",
            "content": [
                {
                    "type": "text",
                    "text": "Please convert the following JSON data into a CSV file:  \n  \n[  \n  {  \n    \"name\": \"John Doe\",  \n    \"age\": 30,  \n    \"city\": \"New York\",  \n    \"email\": \"[email protected]\"  \n  },  \n  {  \n    \"name\": \"Jane Smith\",  \n    \"age\": 25,  \n    \"city\": \"London\",  \n    \"email\": \"[email protected]\"  \n  },  \n  {  \n    \"name\": \"Bob Johnson\",  \n    \"age\": 35,  \n    \"city\": \"Paris\",  \n    \"email\": \"[email protected]\"  \n  }  \n]  \n  \nRequirements:  \n- Columns in the CSV should be in the order: name, age, city, email  \n- Use semicolons (;) as delimiters  \n- Enclose all values in double quotes (\")"
                }
            ]
        }
    ]
)
print(message.content)

import { AnthropicVertex } from '@anthropic-ai/vertex-sdk';

// Reads from the `CLOUD_ML_REGION` & `ANTHROPIC_VERTEX_PROJECT_ID` environment variables.
// Additionally goes through the standard `google-auth-library` flow.
const client = new AnthropicVertex();

const msg = await client.messages.create({
  model: "claude-3-sonnet@20240229",
  max_tokens: 1000,
  temperature: 0,
  system: "As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.",
  messages: [
    {
      "role": "user",
      "content": [
        {
          "type": "text",
          "text": "Please convert the following JSON data into a CSV file:  \n  \n[  \n  {  \n    \"name\": \"John Doe\",  \n    \"age\": 30,  \n    \"city\": \"New York\",  \n    \"email\": \"[email protected]\"  \n  },  \n  {  \n    \"name\": \"Jane Smith\",  \n    \"age\": 25,  \n    \"city\": \"London\",  \n    \"email\": \"[email protected]\"  \n  },  \n  {  \n    \"name\": \"Bob Johnson\",  \n    \"age\": 35,  \n    \"city\": \"Paris\",  \n    \"email\": \"[email protected]\"  \n  }  \n]  \n  \nRequirements:  \n- Columns in the CSV should be in the order: name, age, city, email  \n- Use semicolons (;) as delimiters  \n- Enclose all values in double quotes (\")"
        }
      ]
    }
  ]
});
console.log(msg);

Sumber Daya

​Contoh Output

​Permintaan API

Contoh Output

Permintaan API