Back

Data organizer

Turn unstructured text into bespoke JSON tables.

System
Your task is to take the unstructured text provided and convert it into a well-organized table format using JSON. Identify the main entities, attributes, or categories mentioned in the text and use them as keys in the JSON object. Then, extract the relevant information from the text and populate the corresponding values in the JSON object. Ensure that the data is accurately represented and properly formatted within the JSON structure. The resulting JSON table should provide a clear, structured overview of the information presented in the original text.
user
Silvermist Hollow, a charming village, was home to an extraordinary group of individuals. Among them was Dr. Liam Patel, a 45-year-old Yale-taught neurosurgeon who revolutionized surgical techniques at the regional medical center. Olivia Chen, at 28, was an innovative architect from UC Berkeley who transformed the village's landscape with her sustainable and breathtaking designs. The local theater was graced by the enchanting symphonies of Ethan Kovacs, a 72-year-old Juilliard-trained musician and composer. Isabella Torres, a self-taught chef with a passion for locally sourced ingredients, created a culinary sensation with her farm-to-table restaurant, which became a must-visit destination for food lovers. These remarkable individuals, each with their distinct talents, contributed to the vibrant tapestry of life in Silvermist Hollow.

{ "residents": [ { "name": "Dr. Liam Patel", "age": 45, "profession": "Neurosurgeon", "education": "Yale", "contributions": "Revolutionized surgical techniques at the regional medical center" }, { "name": "Olivia Chen", "age": 28, "profession": "Architect", "education": "UC Berkeley", "contributions": "Transformed the village's landscape with sustainable and breathtaking designs" }, { "name": "Ethan Kovacs", "age": 72, "profession": "Musician and Composer", "education": "Juilliard", "contributions": "Enchanted the local theater with his symphonies" }, { "name": "Isabella Torres", "age": null, "profession": "Chef", "education": "Self-taught", "contributions": "Created a culinary sensation with her farm-to-table restaurant" } ], "village": { "name": "Silvermist Hollow", "description": "A charming village home to extraordinary individuals" } }

Here is the information from the text structured as a JSON object:

json
{
  "village_name": "Silvermist Hollow", 
  "village_description": "a charming village",
  "residents": [
    {
      "name": "Dr. Liam Patel",
      "age": 45, 
      "profession": "neurosurgeon",
      "education": "Yale-taught",
      "achievements": "revolutionized surgical techniques at the regional medical center"
    },
    {
      "name": "Olivia Chen",
      "age": 28,
      "profession": "architect", 
      "education": "UC Berkeley",
      "achievements": "transformed the village's landscape with her sustainable and breathtaking designs"
    },
    {
      "name": "Ethan Kovacs",
      "age": 72,
      "profession": "musician and composer",
      "education": "Juilliard-trained",
      "achievements": "created enchanting symphonies that graced the local theater"
    },
    {
      "name": "Isabella Torres",
      "profession": "chef",
      "achievements": "created a culinary sensation with her farm-to-table restaurant, which became a must-visit destination for food lovers"
    }
  ]
}

I identified the key information as:

  • Name of the village
  • Description of the village
  • Details about each remarkable resident, including their name, age, profession, education, and achievements

I structured this into a JSON object with the village details at the top level, and the resident details nested under a "residents" array. Each resident is represented by an object containing the relevant attributes.

json
{
  "Silvermist Hollow": [
    {
      "name": "Dr. Liam Patel",
      "age": 45,
      "education": "Yale",
      "profession": "Neurosurgeon",
      "accomplishment": "Revolutionized surgical techniques at the regional medical center"
    },
    {
      "name": "Olivia Chen",
      "age": 28,
      "education": "UC Berkeley",
      "profession": "Architect",
      "accomplishment": "Transformed the village's landscape with sustainable and breathtaking designs"
    },
    {
      "name": "Ethan Kovacs",
      "age": 72,
      "education": "Juilliard",
      "profession": "Musician and Composer",
      "accomplishment": "Graced the local theater with enchanting symphonies"
    },
    {
      "name": "Isabella Torres",
      "education": "Self-taught",
      "profession": "Chef",
      "accomplishment": "Created a culinary sensation with her farm-to-table restaurant, which became a must-visit destination for food lovers",
      "restaurant": {
        "type": "Farm-to-table",
        "specialty": "Locally sourced ingredients"
      }
    }
  ]
}

API request

python
import anthropic

  client = anthropic.Anthropic(
      # defaults to os.environ.get("ANTHROPIC_API_KEY")
      api_key="my_api_key",
  )
  message = client.messages.create(
      model="claude-3-opus-20240229",
      max_tokens=2000,
      temperature=0,
      system="Your task is to take the unstructured text provided and convert it into a well-organized table format using JSON. Identify the main entities, attributes, or categories mentioned in the text and use them as keys in the JSON object. Then, extract the relevant information from the text and populate the corresponding values in the JSON object. Ensure that the data is accurately represented and properly formatted within the JSON structure. The resulting JSON table should provide a clear, structured overview of the information presented in the original text.",
      messages=[{"role":"user","content":[{"type":"text","text":"Silvermist Hollow, a charming village, was home to an extraordinary group of individuals. Among them was Dr. Liam Patel, a 45-year-old Yale-taught neurosurgeon who revolutionized surgical techniques at the regional medical center. Olivia Chen, at 28, was an innovative architect from UC Berkeley who transformed the village's landscape with her sustainable and breathtaking designs. The local theater was graced by the enchanting symphonies of Ethan Kovacs, a 72-year-old Juilliard-trained musician and composer. Isabella Torres, a self-taught chef with a passion for locally sourced ingredients, created a culinary sensation with her farm-to-table restaurant, which became a must-visit destination for food lovers. These remarkable individuals, each with their distinct talents, contributed to the vibrant tapestry of life in Silvermist Hollow."}]}]
  )
  print(message.content)
typescript
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-3-opus-20240229",
      max_tokens: 2000,
      temperature: 0,
      system: "Your task is to take the unstructured text provided and convert it into a well-organized table format using JSON. Identify the main entities, attributes, or categories mentioned in the text and use them as keys in the JSON object. Then, extract the relevant information from the text and populate the corresponding values in the JSON object. Ensure that the data is accurately represented and properly formatted within the JSON structure. The resulting JSON table should provide a clear, structured overview of the information presented in the original text.",
      messages: [{"role":"user","content":[{"type":"text","text":"Silvermist Hollow, a charming village, was home to an extraordinary group of individuals. Among them was Dr. Liam Patel, a 45-year-old Yale-taught neurosurgeon who revolutionized surgical techniques at the regional medical center. Olivia Chen, at 28, was an innovative architect from UC Berkeley who transformed the village's landscape with her sustainable and breathtaking designs. The local theater was graced by the enchanting symphonies of Ethan Kovacs, a 72-year-old Juilliard-trained musician and composer. Isabella Torres, a self-taught chef with a passion for locally sourced ingredients, created a culinary sensation with her farm-to-table restaurant, which became a must-visit destination for food lovers. These remarkable individuals, each with their distinct talents, contributed to the vibrant tapestry of life in Silvermist Hollow."}]}]
  });
  console.log(msg);