Skip to main content

!RefLibrary_qmdDocs

QMD Documentation Quick Reference Library

QMD Documentation Quick Reference Library

Creating .qmd Documentation

This is intended to serve as a basic reference for .qmd documents

Most start with a YAML (that is the title at the top of this page in between two sets of three dahes).

Code Chunks - FYI

When creating .qmd documents you can use the following to create code chunks. Eval (evaluation) means you want the code chunk to actually run and display its results in the final document, while include means that you want to display the code chunk (false would mean to hide it) in the final document.

```{r eval=TRUE, include=TRUE} code goes between this and the three end quotes, but each on it's own line.```
```{SQL eval=TRUE, include=TRUE} code ```
```{python eval=TRUE, include=TRUE} code ```

Sample Section Header

This is text, usually with a space between this and the header

SampleSubHeader

This is text, usually with a space between this and the header

  • List
  • List
    • SubList indented
    • SubList indented

SampleSubSubHeader

This is text, usually with a space between this and the header

SampleSubSubSubHeader

This is text, usually with a space between this and the header

This is a code chuck

# THIS IS THE COMMENT

# if you haven't already, open a Terminal and 
# pip install datetime

import datetime

# THIS IS ALSO A COMMENT

the_month = datetime.datetime.now().month
the_day = datetime.datetime.now().day
the_year = datetime.datetime.now().year


# Get the current and next year
current_year = datetime.datetime.now().year
next_year = current_year + 1


print(the_month)


print(the_day)


print(the_year)


print(current_year)


print(next_year)


print(datetime.datetime.now())


print(the_month,the_day,the_year)


print(f"{the_month}/{the_day}/{the_year}")
8
15
2024
2024
2025
2024-08-15 13:24:46.933700
8 15 2024
8/15/2024

Popular posts from this blog

Learning Coding Fundamentals with Python and SQL

Learning Coding Fundamentals with Python and SQL Learning Coding Fundamentals with Python and SQL Darrell Wolfe ————————————————————— Disclaimers First It is not my intention to steal anyone’s thunder or copyrighted material. I do not believe these seven fundamentals are specific to Dr Hill (below), who was the initial inspiration to start this note file. That beings said, she has a particularly unique method of teaching, and I strongly recommend that if you are someone who needs a good teacher, she’s the one! This is my own process of learning. I take information from as many sources and teachers as possible, synthesis that material, and then practice it until I get good at it. Further, I like to take detailed notes so I can refer back to them when a particular tool starts getting rusty or dusty in my brain after disuse for a time. When I learned .rmd through my Google Data Analytics Certification, I

Becoming a Business Intelligene and Data Analyst

In order to learn SQL, here are the steps I'm using: I'm working through: W3 Schools SQL Tutorials   Coursera: Google Data Analytics Professional Certificate   YouTube's Alex the Analyst FREE " Data Analyst Bootcamp!! "  Google Searching to reference as many articles as I can find on various aspects. Using ChatGPT  to check my syntax and explain concepts to me, answering my questions like a tutor.  I've also joined/downloaded/am using: GitHub My Repository:  https://github.com/darrellwolfe/toposcreative SQL Quick Reference notes Trello SQL Server  Express: SQL Server 2022 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications. Visual Studio 2022 Power BI Tableau &  Tableau Public TBC... Shalom  שָׁלוֹם : Live Long and Prosper! Darrell Wolfe Storyteller | Writer | Thinker | Consultant | Freelancer

Using INDIRECT to obtain a VLookup with a variable array reference

Case Study for using INDIRECT to obtain a VLookup with a variable array reference *For reference: I did not build this workbook, it came this way and I'm stuck with it until I can rebuild it correctly next year.* The Problem: I have a legacy workbook that I have to rebuild for next year, but his year I'm stuck with.  This workbook has at or near 100 tabs that need to be referenced on a Totals and Subtotals set of pages. There are a thousand better ways to do that, especially using Power Query and Power Pivot, but here we are. These sub-totals pages were for specific sub-sets of the data that could be found on any given page (Ex: One sub-totals page looks for all properties with a PC Code "548"). On the sub-totals pages, the previous builder had simply linked the cells to the various pages; resulting in over a thousand rows of data that looked like this: //='2001'!$A$20// However, when the end-user filtered the data on the origin pages, the data on the sub-tota