Français
Presentations About Resources

Salesforce, Python, SQL, & other ways to put your data where you need it -- a bilingual blog in English & French

Learn Python

💬 EN

Welcome, beginners!

The web is overflowing with Python tutorials for data science and general-purpose programming. Practical Business Python has the backs of managers and others who live and die by the PivotTable.

But what about people who don’t even want to go in as deep as PivotTables?

This site is for you.

Couldn’t care less about programming, but wish you had a small “macro”-like script for an annoying data cleanup task you do once a week?

This site is for you.

I intend to crash-course non-programmers (and non-Python-programmers) just enough to solve a few “my data looks all wrong!” problems faster, without needing to learn any more programming than is absolutely necessary for the job.

We’ll mostly focus on replacing Excel with Python and its “module” Pandas for cleaning and merging data in CSV files and spreadsheets.

For people who want to do more, like make their code interact directly with Salesforce, we’ll also cover:

  • Understanding the differences between common data formats (CSV/Excel, JSON, XML)
  • Transforming data from one format into another
  • Cleaning and merging JSON & XML data
  • Communicating with vendors’ “REST or SOAP APIs” so that you can automate extraction and loading of your data