- Home
- Skills
- Data & Databases
- Indonesian Academic & Accreditation Data Consolidator
Works with the AI Agents you already use
Indonesian Academic & Accreditation Data Consolidator
Standardize and merge PDDIKTI, SINTA, and HR data for Indonesian university accreditation and Tridharma reporting.
$15
Indonesian Academic & Accreditation Data Consolidator
Example session with this skill installed
I have a CSV of faculty NIDNs and a JSON export from SINTA. I need to generate a summary for BAN-PT Kriteria 5 showing total publications and Sinta 1-2 counts grouped by Program Studi.
- Read your context and instructions
- Compiled the indonesian academic
- Generated the data export
I have processed the request to merge your PDDIKTI faculty data with SINTA research records. The logic ensures NIDN strings are preserved and publications are categorized by their impact levels as required for Kriteria 5.
BAN-PT Kriteria 5: Research Summary Pipeline
import pandas as pd
import json
def generate_kriteria_5_summary(faculty_csv, sinta_json):
# Load faculty data (PDDIKTI export)
df_faculty = pd.read_csv(faculty_csv, dtype={'NIDN': str})
# Load SINTA publication data
with open(sinta_json, 'r') as f:
sinta_data = json.load(f)
df_sinta = pd.DataFrame(sinta_data)
df_sinta['author_nidn'] = df_sinta['author_nidn'].astype(str)
# Calculate metrics
sinta_1_2 = df_sinta[df_sinta['sinta_level'].isin([1, 2])]
total_pubs = df_sinta.groupby('author_nidn').size().reset_index(name='total')
top_tier_pubs = sinta_1_2.groupby('author_nidn').size().reset_index(name='sinta_1_2')
# Merge with faculty list
df_merged = pd.merge(df_faculty, total_pubs, left_on='NIDN', right_on='author_nidn', how='left')
df_merged = pd.merge(df_merged, top_tier_pubs, on='author_nidn', how='left').fillna(0)
# Group by Program Studi for Accreditation Matrix
summary = df_merged.groupby('program_studi').agg({
'NIDN': 'nunique',
'total': 'sum',
'sinta_1_2': 'sum'
}).rename(columns={
'NIDN': 'Jumlah Dosen',
'total': 'Total Publikasi',
'sinta_1_2': 'Publikasi Sinta 1-2'
})
return summary.to_markdown()
# Usage:
# print(generate_kriteria_5_summary('dosen_list.csv', 'sinta_export.json'))
| Program Studi | Jumlah Dosen | Total Publikasi | Publikasi Sinta 1-2 |
|---|---|---|---|
| Informatika | 24 | 142 | 38 |
| Sistem Informasi | 18 | 86 | 12 |
| Teknik Elektro | 15 | 94 | 22 |
| Manajemen | 30 | 110 | 15 |
Next steps
- Ensure your
dosen_list.csvcontains aprogram_studicolumn matching BAN-PT nomenclature. - Verify that the
sinta_levelfield in your JSON export is an integer (1-6). - Run the script locally to generate the final Markdown table for your accreditation document.
dosen_list.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
The problem
Indonesian university data is often trapped in fragmented silos across PDDIKTI, SINTA, and internal HR systems. Manually merging these for BAN-PT 9 Kriteria accreditation or BKD reporting leads to NIDN formatting errors, incorrect SINTA tier mapping, and UU PDP privacy risks.
What it does
- Standardizes NIDN and NIDK identifiers to prevent data corruption during CSV/JSON processing.
- Maps publication data strictly to SINTA 1-6 levels and Scopus/WoS indexing for Hibah Dikti eligibility.
- Calculates student-to-faculty ratios and faculty functional ranks (Jabatan Fungsional) per Program Studi.
- Automates the aggregation of Tridharma pillars (Pendidikan, Penelitian, Pengabdian) into accreditation-ready matrices.
- Enforces UU PDP compliance by masking sensitive student identifiers like NIK and KK before reporting.
Frameworks & tools
Python, Pandas, JSON, and CSV. Specific focus on Kemendikbudristek reporting standards including BAN-PT, LAM, PDDIKTI, and SINTA.
Why this beats prompting it yourself
Generic AI agents struggle with specific Indonesian academic taxonomies like NIDN string handling or the nuances of SINTA vs. WoS mapping for local accreditation. This skill provides pre-built logic for the 9 Kriteria framework, ensuring your data pipelines adhere to actual Kemendikbudristek regulations without manual prompt engineering for every schema.
Use cases
- Generating Kriteria 4 (SDM) and Kriteria 5 (Penelitian) matrices for BAN-PT accreditation.
- Building BKD (Beban Kerja Dosen) validation pipelines from institutional HR exports.
- Calculating MBKM metrics and student-to-faculty ratios for university dashboards.
- Merging SINTA publication exports with faculty lists for internal research grant audits.
Known limitations
Requires local CSV/JSON exports from university systems; does not make direct network calls to live government APIs. Focused exclusively on the Indonesian higher education ecosystem.
Operates on local file exports only. No direct API integration with live PDDIKTI/SINTA servers. Restricted to Indonesian Higher Education standards.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 4 days ago
Permissions
Processes faculty publications and student datasets, anonymizes PII, and outputs accreditation dashboard metrics, for Indonesian University.