Rename a DataFrame Column in PythonAs a data professional do you have a Python dataset that might require some column renaming? Why would […] August 5, 2023 in Python tagged rename / pandas / dataframe / case / unnamed / column / inplace / name / friends / update / renaming / python / field / change / snake by Mike
Change String Case in pandasThere are several ways to change the case in a pandas String. There is upper, lower, title, capitalize […] August 3, 2023 in Python tagged lower / title capitalize / swap / string / case / upper / series / str by Mike
SQL Best PracticesWhen you write SQL queries it is important to follow company policies and be consistent because others will […] January 27, 2023 in SQL tagged sql / case / practice / best by Mike
Text Transformation in Power QueryThis post covers a few common text transformations in Power Query. When you are working with a column, […] December 25, 2022 in Excel tagged text / case / merge / split / delimiter / capitalization / upper / proper / Power Query Transform by Mike
C# IdentifiersIdentifiers are character strings used to name things such as variables, methods, parameters, and a host of other […] December 29, 2018 in C# tagged case / variable / identifier / name / camel / keyword / pascal / snake / naming / identify / C# Getting Started by Mike
SQL Server CaseThe SQL Server Case statement is best explained by example. What Case allows us to do is get […] August 11, 2017 in SQL Server tagged case / when by Mike
SQL Server Strings ConcatenationNumbers and Strings If you want to concatenate a number to a string you need to know how […] July 2, 2017 in SQL Server tagged IIF / concatenation / case / Coalesce / precedence / type / data / convert / cast / string by Mike
Convert Case OnlineDo you need to convert some text from one case to another? Perhaps you left the Caps lock […] February 17, 2017 in Text Editors tagged editor / text / convert / case by Mike