{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"name":"python","version":"3.12.12","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"},"kaggle":{"accelerator":"none","dataSources":[{"sourceId":121150,"databundleVersionId":15061024,"sourceType":"competition"}],"dockerImageVersionId":31234,"isInternetEnabled":true,"language":"python","sourceType":"notebook","isGpuEnabled":false}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"markdown","source":"# SIX TEXTS WITH NEW AND RARE TOPONYMS FROM THE HOUSE OF ALI-AHUM (Kt c/k)\n\n**Jan Gerrit DERCKSEN**\n\nFor over two hundred years, Old Assyrian caravans set out from Assur and travelled to\nKanesh. The route they followed to reach one of the points where the Euphrates could be crossed\nhad some fixed stops, but alternative roads existed and were used to reach Zalpa, Hahhum or Uršu\ndepending on the political situation or commercial considerations. Most of the information about\nthe towns or villages the caravans passed stems from documents that record gifts and expenses and\nwhich were drawn up to settle accounts between the caravan leader who made the payments and\nthe caravan owner or his representative in Kanesh. Often these documents contain previously\nunattested toponyms. Also the six texts from the archive of Ali-ahum (Kt c/k), which are\ncommunicated here ahead of their publication in the series Kültepe Tabletleri, add to our\nknowledge of ancient topography.1 This article is written as a small token in admiration of\nProfessor Cahit Günbattı for his work on the publication and study of texts from ancient Kanesh.\n\n**I took the translations from the PDF, but the transliterations are from the file provided by the DPC**\n","metadata":{}},{"cell_type":"code","source":"import numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\nimport re\nimport os","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true,"execution":{"iopub.status.busy":"2026-01-31T00:20:56.858765Z","iopub.execute_input":"2026-01-31T00:20:56.859082Z","iopub.status.idle":"2026-01-31T00:20:58.375019Z","shell.execute_reply.started":"2026-01-31T00:20:56.859051Z","shell.execute_reply":"2026-01-31T00:20:58.373640Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"INPUT_DIR = \"/kaggle/input/deep-past-initiative-machine-translation\"\n# train_df = pd.read_csv(f\"{INPUT_DIR}/train.csv\")\n# test_df = pd.read_csv(f\"{INPUT_DIR}/test.csv\")\npublished_texts = pd.read_csv(f\"{INPUT_DIR}/published_texts.csv\")","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2026-01-31T00:20:58.377384Z","iopub.execute_input":"2026-01-31T00:20:58.378649Z","iopub.status.idle":"2026-01-31T00:20:58.755559Z","shell.execute_reply.started":"2026-01-31T00:20:58.378576Z","shell.execute_reply":"2026-01-31T00:20:58.754371Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"published_texts","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2026-01-31T00:20:58.756382Z","iopub.execute_input":"2026-01-31T00:20:58.757023Z","iopub.status.idle":"2026-01-31T00:20:58.803103Z","shell.execute_reply.started":"2026-01-31T00:20:58.756984Z","shell.execute_reply":"2026-01-31T00:20:58.802035Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"# This six texts I could find in the published_texts using the codes below.\nTEXTS = ['Kt c/k 763', 'Kt c/k 399', 'Kt c/k 216', 'Kt c/k 441', 'Kt c/k 470+767', 'Kt c/k 766']\n\n# Filter the rows\nfiltered_texts = published_texts[published_texts['excavation_no'].isin(TEXTS)]\n\nprint(filtered_texts)","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2026-01-31T00:20:58.804592Z","iopub.execute_input":"2026-01-31T00:20:58.804952Z","iopub.status.idle":"2026-01-31T00:20:58.823177Z","shell.execute_reply.started":"2026-01-31T00:20:58.804913Z","shell.execute_reply":"2026-01-31T00:20:58.822029Z"}},"outputs":[],"execution_count":null},{"cell_type":"markdown","source":"# Explanations\n\nThe translations are from the article: SIX TEXTS WITH NEW AND RARE TOPONYMS FROM THE HOUSE OF ALI-AHUM (Kt c/k)\n\nJan Gerrit DERCKSEN\n\n**Text 1**: Qa????ara is Qattara with a t with dot below.","metadata":{}},{"cell_type":"code","source":"data = [\n    {'excavation_no': TEXTS[0], \n     'translation': \"\"\"50 zamrutu, 2 5/6 minas of silver, 6 shekels of silver for sheep, all this I gave in Qattara. 1\nsila of fine (oil) of ... for Ala-Adda ...; [I gave] 17 zamrutu for the caravan in Našila.\n(too broken for translation)\n... 6 zamrutu ... in Hazura; all this I gave to the caravan.\"\"\"},\n    {'excavation_no': TEXTS[1], \n     'translation': \"\"\"x sila of aromatic oil, 5 dulbatum and sundries I gave in Šerwun.\n3 shekels of tin I gave to the servant of the kaššum in Inum.\n3 bronze nails and 2 g., two-thirds mina of tin to the nākirum, I gave in Bābum.\nI paid 5 shekels of tin when I went on a mission.\n3 shekels of silver I paid in Burallum for wine after our accounts had been settled.\"\"\"},\n    {'excavation_no': TEXTS[2], \n     'translation': \"\"\"[...] for wine. 3 shekels of tin, 5 dulbatum and\nsundries for Panaka. 5 dulbatum and sundries for Enlil-bāni in Humahum. One-third of a mina of\ncopper for where our donkeys were standing in Humahum. 15 shekels of copper in Zurzu. Half a\nmina of copper to the massu’um of Ašihum. Half a mina minus half a shekel of tin, 10 dulbatum\nand 2 containers(?) of first quality oil and sundries for the palace, 5 shekels of tin, 5 dulbatum and\none container(?) of first quality oil and sundries for the kaššum in Hurumhašum.\"\"\"},\n    {'excavation_no': TEXTS[3], \n     'translation': \"\"\"11 shekels of tin to the servant of Sam’al; 5 shekels of tin and a seal of haematite for his\ncompagnon; 1 mina 2 shekels of tin in Enumgalim for ummanum. 5 beads of carnelian and 2 of\nzikanšarri for wood in Šunukam. 5 dulbatum, 1 muluhum and sundries, a quarter sila of aromatic\noil, 6 ½ shekels of tin for the kaššum of Šunukam. 2 ¼ shekels of tin for wine. 1 ½ shekels of tin\nfor the wife of the kaššum. 6 ½ shekels of tin for the massu’um in the mountain. 7 dulbatum, 1\nmuluhum and sundries, 5 shekels of tin to the wife of the brother of the king of Šehwa. 5/6 mina of\ntin to the palace of Šehwa; 2 shekels of tin to the great man; 3 shekels of tin to the smith; 3 shekels\nof tin for wine; 15 shekels of tin for the kaššum of Šehwa; half a mina and 5 shekels of tin for our\nguide – all this I gave upon <our> entering (the town).\n5 dulbatum, 2 nigirašum and sundries, 1/3 mina of copper to the elders, 15 shekels of copper\nto ...; all this in Tadhul. 3 shekels of tin for wine in Šuhru. 1 sila of aromatic oil, 10 dulbatum, an\namahum, 1 muluhum, sundries and children’s <object> to the palace. 4 G. for the escort, 4\ndulbatum and sundries, 2 shekels of tin for the priest. 3 1/3 shekels of tin for wine, 1 2/3 shekels of\ntin, also for wine; all this I gave in Burhum.\"\"\"},\n    {'excavation_no': TEXTS[4], \n     'translation': \"\"\"1 shekel of tin to Ilulāya. Half a shekel of tin is with Iliya. I gave him also half a mina of\ncopper and sundries in Hirašta and one-third mina (of copper?) in Uršu. 10 shekels of tin and 10\ndulbatum and sundries to the kaššum of Uršu. 1 ½ shekels of silver export-tax. 1 shekel of silver to\nthe massu’um. 1 shekel of silver for a flask for the god(?). 2 shekels of tin to Sama. One-third mina\nof copper to Inib-Aššur. One-third mina of copper to Gallābum. 1 mina 10 shekels of copper in\nBulbulhum. 5 dulbatum, 1 šinuntum and sundries to the overseer. One-third mina and 3+x shekels\n[...] to the massu’um. 1 abarnium-textile, a šitrum, 10 dulbatum to the king. Furthermore, [...] and 1\nmina of tin to [...]. A šitrum, 10 dulbatum [...] and sundries to Šuku... . 1 mina 10 shekels of tin, a\nšitrum, 10 dulbatum, a muluhum and sundries to the kaššum [...]. 1 šitrum to the kaššum [...]. 3 ½\nshekels of tin [...] ... to Madāya. All this I paid in Mama.\"\"\"},\n    {'excavation_no': TEXTS[5], \n     'translation': \"\"\"12 shekels of copper for the inn. 12 shekels of copper at the bridge. 12 shekels of copper in\nBulbulhum. Half a mina of copper for garments. One-third shekel (of silver) for the inn in Aruwar.\nWe took 10 shekels of silver for our food. Half a shekel of silver šaddu’atum-tax. Half a shekel of\nsilver for the inn in Uršu. 2 shekels of silver were lost during refining.\"\"\"}\n]\n\ndf = pd.DataFrame(data)","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2026-01-31T00:21:40.518684Z","iopub.execute_input":"2026-01-31T00:21:40.519042Z","iopub.status.idle":"2026-01-31T00:21:40.528123Z","shell.execute_reply.started":"2026-01-31T00:21:40.519011Z","shell.execute_reply":"2026-01-31T00:21:40.527158Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"df","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2026-01-31T00:21:47.035824Z","iopub.execute_input":"2026-01-31T00:21:47.037314Z","iopub.status.idle":"2026-01-31T00:21:47.049119Z","shell.execute_reply.started":"2026-01-31T00:21:47.037259Z","shell.execute_reply":"2026-01-31T00:21:47.047668Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"# Join them on the 'excavation_no' column\ntrain_plus = pd.merge(filtered_texts[['oare_id','excavation_no','transliteration']], df, on='excavation_no')\n\nprint(train_plus)","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2026-01-31T00:21:57.200888Z","iopub.execute_input":"2026-01-31T00:21:57.201236Z","iopub.status.idle":"2026-01-31T00:21:57.220540Z","shell.execute_reply.started":"2026-01-31T00:21:57.201203Z","shell.execute_reply":"2026-01-31T00:21:57.219507Z"}},"outputs":[],"execution_count":null},{"cell_type":"code","source":"# Save PDF\ntrain_plus.to_csv('train_plus.csv', index=False)","metadata":{"trusted":true,"execution":{"iopub.status.busy":"2026-01-31T00:22:36.404398Z","iopub.execute_input":"2026-01-31T00:22:36.404816Z","iopub.status.idle":"2026-01-31T00:22:36.417426Z","shell.execute_reply.started":"2026-01-31T00:22:36.404784Z","shell.execute_reply":"2026-01-31T00:22:36.416239Z"}},"outputs":[],"execution_count":null},{"cell_type":"markdown","source":"## Conclusion\n\nLet me know if it increases your Score. UPvote ---> Yes","metadata":{}}]}