fetchjournal.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "from datetime import datetime\n",
    "\n",
    "# Specify journal ISSN and base URL for CrossRef API\n",
    "journal_issn = \"1556-1607\"  # Replace with the journal's ISSN\n",
    "base_url = \"https://api.crossref.org/journals/{}/works\".format(journal_issn)\n",
    "\n",
    "# Get the current year and calculate the starting year (3 years back)\n",
    "current_year = datetime.now().year\n",
    "start_year = current_year - 3\n",
    "\n",
    "# Query parameters\n",
    "params = {\n",
    "    'filter': f'from-pub-date:{start_year},until-pub-date:{current_year}',\n",
    "    'rows': 500,  # Adjust the number of articles to retrieve\n",
    "    'sort': 'published',  # Sort by published date\n",
    "    'order': 'desc',  # Get most recent articles first\n",
    "}\n",
    "\n",
    "# Send the request to CrossRef API\n",
    "response = requests.get(base_url, params=params)\n",
    "\n",
    "# Check if the request was successful\n",
    "if response.status_code == 200:\n",
    "    data = response.json()\n",
    "\n",
    "    # Create a list to store the data\n",
    "    articles = []\n",
    "\n",
    "    # Loop through the items and add to the list\n",
    "    for item in data[\"message\"][\"items\"]:\n",
    "        title = item[\"title\"][0] if item[\"title\"] else \"na\"\n",
    "        pub_date = item[\"created\"][\"date-parts\"][0]  # Get only the date part (without time)\n",
    "        pub_date_str = f\"{pub_date[0]}-{pub_date[1]:02d}-{pub_date[2]:02d}\"  # Format as YYYY-MM-DD\n",
    "        volume = item.get(\"volume\", \"na\")\n",
    "        issue = item.get(\"issue\", \"na\")\n",
    "        article_number = item.get(\"article-number\", \"na\")\n",
    "        doi = f\"https://doi.org/{item['DOI']}\"  # Convert DOI to full URL\n",
    "        articles.append([title, pub_date_str, volume, issue, article_number, doi])\n",
    "\n",
    "    # Create a DataFrame and sort by volume, issue, and article number in descending order\n",
    "    df = pd.DataFrame(articles, columns=[\"Title\", \"PublicationDate\", \"Volume\", \"Issue\", \"ArticleNumber\", \"DOI\"])\n",
    "\n",
    "    # Sort by Volume, Issue, and then Article Number in descending order\n",
    "    df = df.sort_values(by=[\"Volume\", \"Issue\", \"ArticleNumber\", \"PublicationDate\"], ascending=[False, False, False, False])\n",
    "\n",
    "else:\n",
    "    print(\"Failed to retrieve data. Status code:\", response.status_code)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Publication Date</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Issue</th>\n",
       "      <th>Article Number</th>\n",
       "      <th>DOI</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Emergent group understanding: Investigating in...</td>\n",
       "      <td>2024-09-25</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09432-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Comparing the effectiveness of CSCL scripts fo...</td>\n",
       "      <td>2024-08-30</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09434-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Comparing the effects of a collaboration scrip...</td>\n",
       "      <td>2024-08-24</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09430-7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Capturing temporal pathways of collaborative r...</td>\n",
       "      <td>2024-08-14</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09431-6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Revealing the interplay of cognitive, meta-cog...</td>\n",
       "      <td>2024-07-11</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09429-0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Correction: Contesting sociocomputational norm...</td>\n",
       "      <td>2023-10-02</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09410-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Contesting sociocomputational norms: Computer ...</td>\n",
       "      <td>2023-09-06</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09392-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Correction: An artificial intelligence-driven ...</td>\n",
       "      <td>2023-04-10</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09391-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>Correction to: Many are the ways to learn: Ide...</td>\n",
       "      <td>2022-05-12</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-022-09368-8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Initiating scientific collaborations across ca...</td>\n",
       "      <td>2021-06-15</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-021-09345-7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CSCL: a learning and collaboration science?</td>\n",
       "      <td>2024-08-19</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09433-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Collaborative Problem-Solving in Knowledge-Ric...</td>\n",
       "      <td>2024-06-24</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09425-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Knowledge creation through maker practices and...</td>\n",
       "      <td>2024-06-21</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09427-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Combining Danmaku and Discussion Boards: Towar...</td>\n",
       "      <td>2024-06-05</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09426-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The perceptions of task cohesion in collaborat...</td>\n",
       "      <td>2024-05-30</td>\n",
       "      <td>19</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09424-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Editorial notes: on dialogues and sequences</td>\n",
       "      <td>2024-06-04</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09428-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Learning to notice collaboration: examining th...</td>\n",
       "      <td>2024-05-20</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09423-6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Zooming in: The role of nonverbal behavior in ...</td>\n",
       "      <td>2024-05-16</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09422-7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Reflective assessment using analytics and arti...</td>\n",
       "      <td>2024-05-13</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09421-8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Dialogues across time and space in a video-bas...</td>\n",
       "      <td>2024-04-16</td>\n",
       "      <td>19</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09420-9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CSCL has come of age</td>\n",
       "      <td>2024-03-12</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09419-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Effects of group awareness support in CSCL on ...</td>\n",
       "      <td>2024-02-26</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-024-09418-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Taking a stance in the process of learning: De...</td>\n",
       "      <td>2024-02-23</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09416-x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Learning within fiber-crafted algorithms: Post...</td>\n",
       "      <td>2024-02-21</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09412-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Exploring students’ immersive VR experiences a...</td>\n",
       "      <td>2024-02-15</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09413-0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Understanding the effect of differences in pri...</td>\n",
       "      <td>2023-12-29</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09405-0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Studying teacher withitness in the wild: compa...</td>\n",
       "      <td>2023-12-28</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09414-z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Can CPS better prepare 8th graders for problem...</td>\n",
       "      <td>2023-12-27</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09407-y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Reflecting on what counts as collaboration: Re...</td>\n",
       "      <td>2023-12-06</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09415-y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>The role of first-language heterogeneity in th...</td>\n",
       "      <td>2023-11-11</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09411-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Co-constructing knowledge with generative AI t...</td>\n",
       "      <td>2023-10-20</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09409-w</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Identifying collaborative problem-solver profi...</td>\n",
       "      <td>2023-08-30</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09400-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Enhancing student learning and achievement thr...</td>\n",
       "      <td>2023-09-20</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09408-x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>The mechanism and effect of class-wide peer fe...</td>\n",
       "      <td>2023-08-24</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09390-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Exploring the impact of chat-based collaborati...</td>\n",
       "      <td>2023-08-23</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09394-0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Does matching peers at finer-grained levels of...</td>\n",
       "      <td>2023-08-16</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09401-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Promoting knowledge building through meta-disc...</td>\n",
       "      <td>2023-08-10</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09403-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Facilitated model-based reasoning in immersive...</td>\n",
       "      <td>2023-08-09</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09396-y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Understanding young children’s science learnin...</td>\n",
       "      <td>2023-07-31</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09395-z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Gesture-mediated collaboration with augmented ...</td>\n",
       "      <td>2023-07-29</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09398-w</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Mobile augmented reality supporting families’ ...</td>\n",
       "      <td>2023-07-26</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09399-9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Fostering collaborative and embodied learning ...</td>\n",
       "      <td>2023-07-03</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09404-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Coordinating modalities of mathematical collab...</td>\n",
       "      <td>2023-06-27</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09397-x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Common “place” observations about embodiment a...</td>\n",
       "      <td>2023-06-23</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09402-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Fostering regulatory processes using computati...</td>\n",
       "      <td>2023-03-27</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09388-y</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>The temporal dynamics of online problem-based ...</td>\n",
       "      <td>2023-03-26</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09385-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>An artificial intelligence-driven learning ana...</td>\n",
       "      <td>2023-03-26</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09387-z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Editorial: Nine elements for robust collaborat...</td>\n",
       "      <td>2023-03-16</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09389-x</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>An automated group learning engagement analysi...</td>\n",
       "      <td>2023-03-04</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09386-0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Visions of the good in computer-supported coll...</td>\n",
       "      <td>2023-03-04</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>na</td>\n",
       "      <td>https://doi.org/10.1007/s11412-023-09384-2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Title Publication Date Volume  \\\n",
       "0   Emergent group understanding: Investigating in...       2024-09-25     na   \n",
       "1   Comparing the effectiveness of CSCL scripts fo...       2024-08-30     na   \n",
       "2   Comparing the effects of a collaboration scrip...       2024-08-24     na   \n",
       "4   Capturing temporal pathways of collaborative r...       2024-08-14     na   \n",
       "5   Revealing the interplay of cognitive, meta-cog...       2024-07-11     na   \n",
       "26  Correction: Contesting sociocomputational norm...       2023-10-02     na   \n",
       "27  Contesting sociocomputational norms: Computer ...       2023-09-06     na   \n",
       "41  Correction: An artificial intelligence-driven ...       2023-04-10     na   \n",
       "63  Correction to: Many are the ways to learn: Ide...       2022-05-12     na   \n",
       "82  Initiating scientific collaborations across ca...       2021-06-15     na   \n",
       "3         CSCL: a learning and collaboration science?       2024-08-19     19   \n",
       "6   Collaborative Problem-Solving in Knowledge-Ric...       2024-06-24     19   \n",
       "7   Knowledge creation through maker practices and...       2024-06-21     19   \n",
       "8   Combining Danmaku and Discussion Boards: Towar...       2024-06-05     19   \n",
       "10  The perceptions of task cohesion in collaborat...       2024-05-30     19   \n",
       "9         Editorial notes: on dialogues and sequences       2024-06-04     19   \n",
       "11  Learning to notice collaboration: examining th...       2024-05-20     19   \n",
       "12  Zooming in: The role of nonverbal behavior in ...       2024-05-16     19   \n",
       "13  Reflective assessment using analytics and arti...       2024-05-13     19   \n",
       "14  Dialogues across time and space in a video-bas...       2024-04-16     19   \n",
       "15                               CSCL has come of age       2024-03-12     19   \n",
       "16  Effects of group awareness support in CSCL on ...       2024-02-26     19   \n",
       "17  Taking a stance in the process of learning: De...       2024-02-23     19   \n",
       "18  Learning within fiber-crafted algorithms: Post...       2024-02-21     19   \n",
       "19  Exploring students’ immersive VR experiences a...       2024-02-15     19   \n",
       "23  Understanding the effect of differences in pri...       2023-12-29     18   \n",
       "20  Studying teacher withitness in the wild: compa...       2023-12-28     18   \n",
       "22  Can CPS better prepare 8th graders for problem...       2023-12-27     18   \n",
       "21  Reflecting on what counts as collaboration: Re...       2023-12-06     18   \n",
       "24  The role of first-language heterogeneity in th...       2023-11-11     18   \n",
       "25  Co-constructing knowledge with generative AI t...       2023-10-20     18   \n",
       "29  Identifying collaborative problem-solver profi...       2023-08-30     18   \n",
       "28  Enhancing student learning and achievement thr...       2023-09-20     18   \n",
       "30  The mechanism and effect of class-wide peer fe...       2023-08-24     18   \n",
       "31  Exploring the impact of chat-based collaborati...       2023-08-23     18   \n",
       "32  Does matching peers at finer-grained levels of...       2023-08-16     18   \n",
       "33  Promoting knowledge building through meta-disc...       2023-08-10     18   \n",
       "35  Facilitated model-based reasoning in immersive...       2023-08-09     18   \n",
       "34  Understanding young children’s science learnin...       2023-07-31     18   \n",
       "37  Gesture-mediated collaboration with augmented ...       2023-07-29     18   \n",
       "36  Mobile augmented reality supporting families’ ...       2023-07-26     18   \n",
       "39  Fostering collaborative and embodied learning ...       2023-07-03     18   \n",
       "40  Coordinating modalities of mathematical collab...       2023-06-27     18   \n",
       "38  Common “place” observations about embodiment a...       2023-06-23     18   \n",
       "46  Fostering regulatory processes using computati...       2023-03-27     18   \n",
       "44  The temporal dynamics of online problem-based ...       2023-03-26     18   \n",
       "47  An artificial intelligence-driven learning ana...       2023-03-26     18   \n",
       "45  Editorial: Nine elements for robust collaborat...       2023-03-16     18   \n",
       "42  An automated group learning engagement analysi...       2023-03-04     18   \n",
       "43  Visions of the good in computer-supported coll...       2023-03-04     18   \n",
       "\n",
       "   Issue Article Number                                         DOI  \n",
       "0     na             na  https://doi.org/10.1007/s11412-024-09432-5  \n",
       "1     na             na  https://doi.org/10.1007/s11412-024-09434-3  \n",
       "2     na             na  https://doi.org/10.1007/s11412-024-09430-7  \n",
       "4     na             na  https://doi.org/10.1007/s11412-024-09431-6  \n",
       "5     na             na  https://doi.org/10.1007/s11412-024-09429-0  \n",
       "26    na             na  https://doi.org/10.1007/s11412-023-09410-3  \n",
       "27    na             na  https://doi.org/10.1007/s11412-023-09392-2  \n",
       "41    na             na  https://doi.org/10.1007/s11412-023-09391-3  \n",
       "63    na             na  https://doi.org/10.1007/s11412-022-09368-8  \n",
       "82    na             na  https://doi.org/10.1007/s11412-021-09345-7  \n",
       "3      3             na  https://doi.org/10.1007/s11412-024-09433-4  \n",
       "6      3             na  https://doi.org/10.1007/s11412-024-09425-4  \n",
       "7      3             na  https://doi.org/10.1007/s11412-024-09427-2  \n",
       "8      3             na  https://doi.org/10.1007/s11412-024-09426-3  \n",
       "10     3             na  https://doi.org/10.1007/s11412-024-09424-5  \n",
       "9      2             na  https://doi.org/10.1007/s11412-024-09428-1  \n",
       "11     2             na  https://doi.org/10.1007/s11412-024-09423-6  \n",
       "12     2             na  https://doi.org/10.1007/s11412-024-09422-7  \n",
       "13     2             na  https://doi.org/10.1007/s11412-024-09421-8  \n",
       "14     2             na  https://doi.org/10.1007/s11412-024-09420-9  \n",
       "15     1             na  https://doi.org/10.1007/s11412-024-09419-2  \n",
       "16     1             na  https://doi.org/10.1007/s11412-024-09418-3  \n",
       "17     1             na  https://doi.org/10.1007/s11412-023-09416-x  \n",
       "18     1             na  https://doi.org/10.1007/s11412-023-09412-1  \n",
       "19     1             na  https://doi.org/10.1007/s11412-023-09413-0  \n",
       "23     4             na  https://doi.org/10.1007/s11412-023-09405-0  \n",
       "20     4             na  https://doi.org/10.1007/s11412-023-09414-z  \n",
       "22     4             na  https://doi.org/10.1007/s11412-023-09407-y  \n",
       "21     4             na  https://doi.org/10.1007/s11412-023-09415-y  \n",
       "24     4             na  https://doi.org/10.1007/s11412-023-09411-2  \n",
       "25     4             na  https://doi.org/10.1007/s11412-023-09409-w  \n",
       "29     4             na  https://doi.org/10.1007/s11412-023-09400-5  \n",
       "28     3             na  https://doi.org/10.1007/s11412-023-09408-x  \n",
       "30     3             na  https://doi.org/10.1007/s11412-023-09390-4  \n",
       "31     3             na  https://doi.org/10.1007/s11412-023-09394-0  \n",
       "32     3             na  https://doi.org/10.1007/s11412-023-09401-4  \n",
       "33     3             na  https://doi.org/10.1007/s11412-023-09403-2  \n",
       "35     2             na  https://doi.org/10.1007/s11412-023-09396-y  \n",
       "34     2             na  https://doi.org/10.1007/s11412-023-09395-z  \n",
       "37     2             na  https://doi.org/10.1007/s11412-023-09398-w  \n",
       "36     2             na  https://doi.org/10.1007/s11412-023-09399-9  \n",
       "39     2             na  https://doi.org/10.1007/s11412-023-09404-1  \n",
       "40     2             na  https://doi.org/10.1007/s11412-023-09397-x  \n",
       "38     2             na  https://doi.org/10.1007/s11412-023-09402-3  \n",
       "46     1             na  https://doi.org/10.1007/s11412-023-09388-y  \n",
       "44     1             na  https://doi.org/10.1007/s11412-023-09385-1  \n",
       "47     1             na  https://doi.org/10.1007/s11412-023-09387-z  \n",
       "45     1             na  https://doi.org/10.1007/s11412-023-09389-x  \n",
       "42     1             na  https://doi.org/10.1007/s11412-023-09386-0  \n",
       "43     1             na  https://doi.org/10.1007/s11412-023-09384-2  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[0:50]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "data[\"message\"][\"items\"][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}