converter.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "fb85d6b8",
   "metadata": {},
   "source": [
    "# Converter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "310332fc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import json\n",
    "import markdown\n",
    "from weasyprint import HTML\n",
    "from converter import md2df, df2json\n",
    "\n",
    "import os\n",
    "home = os.path.expanduser(\"~\")\n",
    "\n",
    "print('OS path is set to:', home)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "edd7b4b3",
   "metadata": {},
   "source": [
    "# md2df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "71435986",
   "metadata": {},
   "outputs": [],
   "source": [
    "help(md2df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8a3b7cc2",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = md2df('pgm_features_codebook.md')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1d42dbe8",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "df.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9d3a4178",
   "metadata": {},
   "source": [
    "# Convert the DF to a Json File"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ffa703a1",
   "metadata": {},
   "outputs": [],
   "source": [
    "json_file = df.to_json(orient=\"index\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f33299bc",
   "metadata": {},
   "outputs": [],
   "source": [
    "json_file"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9bf33743",
   "metadata": {},
   "source": [
    "# Save the Json File"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "90ebd899",
   "metadata": {},
   "source": [
    "# df2json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "43f2ac50",
   "metadata": {},
   "outputs": [],
   "source": [
    "help(df2json)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ed6f3972",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2json(df, file_name= 'pgm_features_codebook.json', save_path='/Users/chandlerwilliams/Desktop/VIEWS_new/codebook/')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d16d9b27",
   "metadata": {},
   "source": [
    "## Test to make sure the Json file loads back to a DataFrame properly"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "47894b5e",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = pd.read_json('pgm_features_codebook.json', orient='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e12bc6b9",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "51f133af",
   "metadata": {},
   "source": [
    "# Converting the DataFrame back to a markdown table\n",
    "\n",
    "    We've gone full circle now. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dff30291",
   "metadata": {},
   "outputs": [],
   "source": [
    "print(df.to_markdown())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b01fc184",
   "metadata": {},
   "source": [
    "# Convert MD to PDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "33f63fbf",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the Markdown file\n",
    "with open('pgm_features_codebook.md', 'r') as f:\n",
    "    markdown_text = f.read()\n",
    "\n",
    "# Convert Markdown to HTML\n",
    "html = markdown.markdown(markdown_text)\n",
    "\n",
    "# Convert HTML to PDF using WeasyPrint\n",
    "HTML(string=html).write_pdf('pgm_features_codebook.pdf')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}