Two scripts help you to convert csv file to md file by template

Overview

csv2md_by_template (csv2mdt.py)

  • this script helps you to convert csv file to multiple md files by template, the filename of each comes from first column in your csv file.
  • this idea came from dicussion with @candideu !

csv2md_blocks_by_template (csv2mdbt.py)

  • this script helps you to convert csv file to single md file with several blocks by template. the first-level block of each comes from first column in your csv file. the name of output file is the same as input csv file.

Preparation

  • python3
  • pandas
  • template.md
  • filename.csv

Caution

  • the variables in template.md should be like $title, $name or $title_name (no blank in variables, please replace blank with '_' by yourself)
  • the variables in template.md should match the first row (colume name) in data.csv
  • but you don't need to replace the blank in column name in csv file by yourself. script will do that. So you can keep column name in csv file as "title name"

Quick start

  • csv2md_by_template (csv2mdt.py)

    • download csv2mdt.py and put it in the same folder as template.md and filename.csv
    • use shell and 'cd' to that folder
    • use follow command

      python csv2mdt.py filename.csv

  • csv2md_blocks_by_template (csv2mdbt.py)

    • download csv2mdbt.py and put it in the same folder as template.md and filename.csv
    • use shell and 'cd' to that folder
    • use follow command

      python csv2mdbt.py filename.csv

  • the output file(s) will be automatically generated in the same folders

  • you can use template.md and data.csv in this repo to play around!

Video

  • csv2md_by_template (csv2mdt.py)
153729075-4263ff1b-68c6-4309-bcfc-1075c82d330c.mp4
  • csv2md_blocks_by_template (csv2mdbt.py)
2022-02-13.14.12.22.mp4

Advanced

  • you can edit the script somehow, such as the path to your template.md and the path to your csv file
  • you can also put the script in $PATH, to make it easier to call
You might also like...
Extract an archive file (zip file or tar file) stored on AWS S3

S3 Extract Extract an archive file (zip file or tar file) stored on AWS S3. Details Downloads archive from S3 into memory, then extract and re-upload

LightCSV - This CSV reader is implemented in just pure Python.

LightCSV Simple light CSV reader This CSV reader is implemented in just pure Python. It allows to specify a separator, a quote char and column titles

Transforme rapidamente seu arquivo CSV (de qualquer tamanho) para SQL de forma rápida.

Transformador de CSV para SQL Transforme rapidamente seu arquivo CSV (de qualquer tamanho) para SQL de forma rápida, e com isso insira seus dados usan

Sheet Data Image/PDF-to-CSV Converter

Sheet Data Image/PDF-to-CSV Converter

CSV To VCF (Multiples en un archivo)

CSV To VCF Convierte archivo CSV a Tarjeta VCF (varias en una) How to use En main.py debes reemplazar CONTACTOS.csv por tu archivo csv, y debes respet

Add Ranges and page numbers to IIIF Manifest from a CSV.

Add Ranges and page numbers to IIIF Manifest from CSV specific to a workflow of the Bibliotheca Hertziana.

CSV-Handler written in Python3

CSVHandler This code allows you to work intelligently with CSV files. A file in CSV syntax is converted into several lists, which are combined in a to

Nmap XML output to CSV and HTTP/HTTPS URLS.

xml-to-csv-url Convert NMAP's XML output to CSV file and print URL addresses for HTTP/HTTPS ports. NOTE: OS Version Parsing is not working properly ye

CleverCSV is a Python package for handling messy CSV files.
CleverCSV is a Python package for handling messy CSV files.

CleverCSV is a Python package for handling messy CSV files. It provides a drop-in replacement for the builtin CSV module with improved dialect detection, and comes with a handy command line application for working with CSV files.

Comments
  • Conditional Fields, Empty csv cells

    Conditional Fields, Empty csv cells

    Hello! Is there any way of making so that if a cell in the csv is empty, it doesn't appear in the output? Right now, it displays "nan", but I just want nothing to be rendered.

    I also wonder if it's possible to extend this by using if/else. For example:

    Hi $recipient
    
    [if there's no $name, display nothing; else:]
      My name is $name!
    [end of condition]
    
    Best,
    
    Management
    
    opened by candideu 0
Owner
null
csv2ir is a script to convert ir .csv files to .ir files for the flipper.

csv2ir csv2ir is a script to convert ir .csv files to .ir files for the flipper. For a repo of .ir files, please see https://github.com/logickworkshop

Alex 38 Dec 31, 2022
Automatically generates a TypeQL script for doing entity and relationship insertions from a .csv file, so you don't have to mess with writing TypeQL.

Automatically generates a TypeQL script for doing entity and relationship insertions from a .csv file, so you don't have to mess with writing TypeQL.

null 3 Feb 9, 2022
Generates a clean .txt file of contents of a 3 lined csv file

Generates a clean .txt file of contents of a 3 lined csv file. File contents is the .gml file of some function which stores the contents of the csv as a map.

Alex Eckardt 1 Jan 9, 2022
A simple Python code that takes input from a csv file and makes it into a vcf file.

Contacts-Maker A simple Python code that takes input from a csv file and makes it into a vcf file. Imagine a college or a large community where each y

null 1 Feb 13, 2022
A python script to convert an ucompressed Gnucash XML file to a text file for Ledger and hledger.

README 1 gnucash2ledger gnucash2ledger is a Python script based on the Github Gist by nonducor (nonducor/gcash2ledger.py). This Python script will tak

Thomas Freeman 0 Jan 28, 2022
The best way to convert files on your computer, be it .pdf to .png, .pdf to .docx, .png to .ico, or anything you can imagine.

The best way to convert files on your computer, be it .pdf to .png, .pdf to .docx, .png to .ico, or anything you can imagine.

JareBear 2 Nov 20, 2021
Convert All TXT Files To One File.

AllToOne Convert All TXT Files To One File. Hi ?? , I'm Alireza A Python Developer Boy ?? I’m currently working on my C# projects ?? I’m currently Lea

null 4 Jun 7, 2022
This program can help you to move and rename many files at once

This program can help you to rename and save many files in a folder in seconds, but don't give the same name to files, it can delete both files.

João Assalim 1 Oct 10, 2022
This is a file deletion program that asks you for an extension of a file (.mp3, .pdf, .docx, etc.) to delete all of the files in a dir that have that extension.

FileBulk This is a file deletion program that asks you for an extension of a file (.mp3, .pdf, .docx, etc.) to delete all of the files in a dir that h

Enoc Mena 1 Jun 26, 2022
PaddingZip - a tool that you can craft a zip file that contains the padding characters between the file content.

PaddingZip - a tool that you can craft a zip file that contains the padding characters between the file content.

phithon 53 Nov 7, 2022