[Video] How to Analyze Simple Data with Libre Office Calc

Uncensored Video Links: BitChute NewTube

Video on how to perform a simple analysis of simple data in LibreOffice Calc, a free open-source “clone” of Microsoft Excel. Demonstrates how to use the Trend Line feature in LibreOffice Calc Charts. Discusses how to use the R Squared goodness of fit statistic to evaluate the analysis.

(C) 2022 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Book Review] Pandemia by Alex Berenson

Pandemia: How Coronavirus Hysteria Took Over Our Government, Rights, and Lives

Alex Berenson

Regnery Publishing, Washington, D.C., 2021

Pandemia is a detailed, somewhat technical history of the COVID pandemic and COVID response mostly in the United States strongly critiquing much of the mainstream news coverage, the lockdown and masking policies, and many claims and policies promoted by the US CDC, Anthony Fauci, and other “public health authorities.” Alex Berenson is a former New York Times investigative reporter who covered many pharmaceutical stories and scandals while working at the Times. I first encountered him through his 2004 book The Number about manipulation and outright fraud in reported quarterly corporate earnings.

The book is written in a breezy, easy to read style with short topical chapters in a roughly chronological order. It has numerous footnotes with a footnote section at the end of the book as well as an index, all to back up his many assertions that differ from most mainstream news coverage, statements by Fauci and other “experts,” and the supposed consensus of scientists. Readers who have been following non-mainstream coverage of the pandemic and pandemic response from sources such as Berenson will not be surprised or find much new. Overall it is a well written, informative book that conveys Berenson’s positions with references to supporting information.

Some Weak Spots

I am not a Conspiracy Theorist

Berenson is adamant that he is not a “conspiracy theorist,” the dread phrase used to shut down any discussion of possible criminal conspiracy or even incompetence by the powerful (such as the “conspiracy theory” that NIH funded “gain of function” research at the Wuhan Institute of Virology produced and then accidentally released SARS-COV-2). Consequently, while he documents baffling failures, claims, and outright contradictory statements by Anthony Fauci, the CDC, and other “public health authorities” such as the dramatic reversal on the effectiveness of masks from “useless” to “highly effective” in April 2020, he stops there and rains scorn on “conspiracy theorists.”

Twitter Warrior

Berenson was eventually banned by Twitter for alleged “COVID misinformation” following what Berenson argues is pressure by the Biden administration and other political figures. He describes many provocative and sometimes offensive tweets which drew a lot of attention to himself, undoubtedly boosting sales of his Unreported Truths booklets on Amazon and now his Pandemia book. He mentions some criticism by his wife Jackie of the aggressive, snarky tone and content of many of his tweets. His substack posts continue to show a similar aggressive, snarky tone today.

Long, Long COVID (Chapter 25)

Berenson is highly skeptical of alleged “Long COVID,” linking it to a range of murky diseases such as chronic fatigue syndrome, fibromyalgia, chronic Lyme disease, and others with arguably similar symptoms which also tend to disproportionately affect women, suggesting a psychological/anxiety cause. He argues that scientists and medical doctors have so far been unable (he says) to find an underlying biological cause or correlate (more on this in a moment) whereas they supposedly found the cause of AIDS (the HIV virus) in only two years. Touting modern high tech molecular biology based science and medicine, he argues it could not be that hard to find a cause if these disease were “real.”

Blaming anxious hysterical women for phantom diseases that disproportionately affect women is not a new phenomenon. Multiple sclerosis (MS) was considered such as disease until a series of autopsies of patients showed lesions (damage) to the nerves. Today MS can be detected with magnetic resonance imaging (MRI) scans which always or frequently show lesions on the nerves in the images.

Both MS and lupus, which disproportionately affect women, continue to be misdiagnosed as psychological problems without an MRI scan or the test for the anti-nuclear antibodies (ANA). About 90 percent of people with lupus (linked article from Lupus Foundation claims 97%) have the unusual anti-nuclear antibodies while only about 5 percent of health individuals have the antibodies. Note that anti-nuclear antibodies are highly correlated with lupus but not perfectly correlated, which raises some questions whether the auto-immune reaction is the true cause of lupus. Alleged auto-immune diseases such as MS, lupus, and rheumatoid arthritis which disproportionately affect women remain mysterious.

MRI scans are unable to image damage to the critical myelin insulating sheath that enclosing nerves. Damage or loss of this sheath which occurs in carpal tunnel syndrome, ulnar and other nerve injuries can be confirmed in many but not all cases with nerve conduction tests. These tests have a several percent failure rate. Damage or loss of the myelin sheath frequently causes extreme levels of pain and in some cases atrophy of the muscles controlled by the nerve.

There are many diseases that have eluded detailed biological analysis. Berenson touts the sequencing of the human DNA as an illustration of the enormous power of modern medical biology without considering about 98% of the human DNA is purported junk DNA whose function is unknown. He extols modern molecular biology research without considering the dismal results of the “War on Cancer” nor the remarkably complex modern theory of cancer with hundreds of oncogenes, allegedly rapidly mutating cancer cells, extensive unpredictable chromosomal changes, and the mysterious anaerobic metabolism seen in many cancer cells.

Could COVID or other disease like Lyme disease occasionally produce some mysterious long lasting, possibly auto-immune syndrome disproportionately in women who disproportionately suffer from alleged auto-immune diseases such as MS, Lupus, and Rheumatoid Arthritis? Quite possibly.

Conclusion

Overall Pandemia is a well written, easy to read book, almost 400 pages of detailed discussion of the COVID pandemic and the lockdowns and other pandemic responses. Berenson makes a strong case that most of the responses have been ineffective at best and even quite harmful in some cases. He avoids speculation about possible conspiracies whether due to genuine skepticism or to avoid the dreaded “conspiracy theorist” label. He stays away from the safety and effectiveness of drugs such as hydroxychloroquine and ivermectin and says little about Vitamin D. He is highly critical of the approval process for the mRNA spike protein based vaccines and the actual real-world safety and effectiveness of the vaccines.

(C) 2022 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Article] Known Problems with US CDC’s Pneumonia, Influenza, and COVID-19 (PIC) Death Numbers

Introduction

This is a summary (below) of our lengthy (about 13,000 word) paper on the many issues with the CDC’s pneumonia, influenza, and COVID-19 (PIC) death numbers. It is about 1,000 words in length (5-10 minute read) and summarizes most of our key findings.

John F. McGowan, Ph.D., Tam Hunt, Josh Mitteldorf, PhD. Improving CDC Data Practices Recommendations for Improving the United States Centers for Disease Control (CDC) Data Practices for Pneumonia, Influenza, and COVID-19 (v 1.1). Authorea. November 29, 2021. DOI:10.22541/au.163822197.79126460/v1
(https://doi.org/10.22541/au.163822197.79126460/v1)

URL:
https://www.authorea.com/users/425106/articles/547336-improving-cdc-data-practices-recommendations-for-improving-the-united-states-centers-for-disease-control-cdc-data-practices-for-pneumonia-influenza-and-covid-19-v-1-1

Key Points/Summary

A number of CDC data presentation and statistical practices since the start of the COVID-19 pandemic in early 2020 have not followed common scientific and engineering practice. Several problems with data presentation and analyses for pneumonia and influenza death numbers – which have been merged with COVID-19 death numbers in the FluView web site ‒ predate the pandemic.

Before the pandemic (March 2020), the non-standard data presentation and statistical practices appear to increase the number of deaths attributed to the influenza virus and imply the death counts are certain whereas substantial uncertainty exists due to uncertainty in the assignment of the cause of death and other reasons. Since the pandemic, these practices appear to do the same for SARS-COV-2 and COVID-19.

Remarkably, the CDC had at least three (3) different numbers for deaths attributed to pneumonia and influenza before 2020: the leading causes of death report count with about two (2) percent of deaths (about 55,000) per year attributed to influenza and pneumonia, the influenza virus deaths model with about 55,000 deaths per year attributed specifically to the influenza virus, and the FluView web site count with about 6-8 percent of deaths (about 188,000) per year attributed to pneumonia and influenza.

The FluView number differs from the other two death numbers by a factor of OVER THREE. The probable reason for this difference is that — according to the FluView technical notes — FluView counts deaths where pneumonia or influenza is listed as “a cause of death” whereas the leading cause of death report — according to the technical notes — counts only deaths where pneumonia or influenza is listed as “the underlying cause of death.” This probably reflects a large uncertainty in the assignment of the cause of death in respiratory illness cases; indeed the underlying cause of death may be ill-defined in many cases.

The CDC’s excess deaths estimates on their excess deaths web site does not report any standard goodness of fit statistics, notably the coefficient of determination often known as “R squared” and the “chi squared” goodness of fit statistic. Our analysis shows that different models with the same goodness of fit statistics give different estimates of the number of excess deaths, varying by up to 200,000 deaths in 2020. The CDC web site does not report this systematic modeling error.

The CDC appears to have chosen a set of parameters for the Noufaily/Farrington algorithm used to estimate excess deaths by the CDC that gives a lower “R Squared” value for goodness of fit than other choices and a HIGHER ESTIMATE of excess deaths — whereas common scientific and engineering practice would be to use the models with the best goodness of fit statistics, the “R Squared” closest to 1.0.

The Noufailly/Farrington algorithm is an empirical trend detection and extrapolation model theoretically incapable of accurately modeling the aging “baby boom” population which would be expected to produce “excess deaths” in recent years — nor is it able to explain the puzzling near stop of the increase in deaths per year reported in the immediate pre-pandemic years 2017-2019 despite the aging population.

The CDC does not publish (as of Dec 2021) years of life lost (YLL) estimates which include increases in suicides, homicides, and other adverse effects of the lockdowns, nor systematic modeling errors on the YLL estimates. YLL can illustrate the difference between a disease that largely kills those nearing death anyway versus a disease that easily kills the healthy.

The CDC issued a COVID death certificate guidance document in April of 2020 that appears to change the standards for assigning the underlying cause of death (UCOD) from the pre-pandemic practice for assigning the underlying cause of death for pneumonia and influenza, making COVID-19 the underlying cause of death in the many cases where the person who died had serious pre-existing conditions such as chronic bronchitis, emphysema, heart failure etc.. — the deaths counted in FluView but not in the leading causes of death report. There does not appear to have been any public comment on this guidance document to date.

In general the CDC does not report statistical errors, systematic errors, or estimates of biases in pneumonia, influenza, and COVID-19 death numbers. They do not report any monitoring of the effect of their guidance documents or other directives on the assignment of the cause of death by doctors, medical examiners, and others.

These issues are sometimes shared with other government agencies such as the US Social Security Administration (SSA) and US Census Bureau that work closely with the CDC.

Death counts for both individual causes and “all cause” deaths are frequently reported as precise to the last digit without any statistical or systematic errors, despite both known and unknown uncertainties in counting deaths, such as missing persons, unreported deaths due to deceased payee fraud, the ~1,000 living Americans incorrectly added to the government Deaths Master File (DMF), each month, for unknown reasons, and considerable uncertainties in assigning the underlying cause of death (UCOD) by coroners and doctors.

Similarly, raw counts, adjusted counts, and estimates – often based on incompletely documented computer mathematical models – are often not clearly identified as such. The Deaths Master File, with names and dates of death of deceased persons is exempt from the Freedom of Information Act (FOIA) and unavailable to the general public, independent researchers, and even other government agencies such as the IRS. This confidentiality of data makes independent verification of many CDC numbers, such as the excess deaths numbers tracked during the COVID-19 pandemic, all but impossible.

This omission of common scientific and engineering practices raises questions about the accuracy of the CDC’s data, conclusions, and public health policies in a number of important areas, including the COVID-19 pandemic.

The non-standard data presentation and statistical practices appear to increase the number of deaths attributed to the influenza virus and imply the death counts are certain whereas substantial uncertainty exists due to uncertainty in the assignment of the cause of death and other causes. Since the pandemic, these practices appear to do the same for SARS-COV-2 and COVID-19.

END OF SUMMARY

(C) 2021 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] CDC Provincetown COVID-19 Outbreak Data Does NOT Show Vaccines Working

https://odysee.com/@MathematicalSoftware:5/cdc-provincetown-covid-19-outbreak-data-does-not-show-vaccines-work:3

Alternative Video: NewTube Brighteon BitChute ARCHIVE

The Provincetown, Massachusetts (Cape Cod, Barnstable County) COVID-19 outbreak does NOT prove that the COVID-19 vaccines are working as widely claimed in the mainstream media. (See the CDC Report “Outbreak of SARS-CoV-2 Infections, Including COVID-19 Vaccine Breakthrough Infections, Associated with Large Public Gatherings — Barnstable County, Massachusetts,” https://www.cdc.gov/mmwr/volumes/70/wr/pdfs/mm7031e2-H.pdf)

Article: http://wordpress.jmcgowan.com/wp/article-us-cdc-provincetown-covid-19-outbreak-data-does-not-show-vaccines-work/

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Locals (Video): https://mathematicalsoftware.locals.com/
Archive (Video): https://archive.org/details/@mathsoft

(C) 2021 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Article] Improving CDC Data Practices: Recommendations for Improving the United States Centers for Disease Control (CDC) Data Practices for Pneumonia, Influenza, and COVID-19

This is a preprint of a new academic paper written by Tam Hunt, Josh Mitteldorf, Ph.D. and myself on the US Centers for Disease Control (CDC)’s data practices during the COVID-19 pandemic and for pneumonia and influenza prior to the pandemic. I am the corresponding author.

Abstract

During the pandemic, millions of Americans have become acquainted with the CDC because its reports and the data it collects affect their day-today lives. But the methodology used and even some of the data collected by CDC remain opaque to the public and to the community of academic epidemiology. In this paper, we highlight areas in which CDC methodology might be improved and where greater transparency might lead to broad collaboration. (1) “Excess” deaths are routinely reported, but not “years of life lost”, an easily-computed datum that is important for public policy. (2) What counts as an “excess death”? The method for computing the number of excess deaths does not include error bars and we show a substantial range of estimates is possible. (3) Pneumonia and influenza death data on different CDC pages is grossly contradictory. (4) The methodology for computing influenza deaths is not described in sufficient detail that an outside analyst might pursue the source of the discrepancy. (5) Guidelines for filling out death certificates have changed during the COVID-19 pandemic, preventing the comparison of 2020-21 death profiles with any previous year. We conclude with a series of explicit recommendations for greater consistency and transparency, and ultimately to make CDC data more useful to outside epidemiologists.

John F. McGowan, Ph.D., Tam Hunt, Josh Mitteldorf. Improving CDC Data Practices Recommendations for Improving the United States Centers for Disease Control (CDC) Data Practices for Pneumonia, Influenza, and COVID-19. Authorea. July 19, 2021.
DOI: 10.22541/au.162671168.86830026/v1

Here are the key recommendations from the paper:

Recommendations

In light of the previous discussion, we make a number of recommendations to improve CDC’s data practices, including improved observance of common scientific and engineering practice – such as use of significant figures and reporting of statistical and systematic errors. Common scientific and engineering practice is designed to prevent serious errors and should be followed rigorously in a crisis such as the COVID-19 pandemic.

Note that some of these recommendations may require changes in federal or state laws, federal or state regulations, or renegotiation of contracts between the federal government and states. This is probably the case for making the Deaths Master File (DMF), with names and dates of death of persons reported as deceased to the states and federal government, freely available to the public and other government agencies.

  • All CDC numbers, where possible, should be clearly identified as estimates, adjusted counts, or raw counts, with statistical errors and systematic errors given, using consistent clear standard language in all documents. The errors should be provided as both ninety-five percent (95%) confidence level intervals and the standard deviation – at least for the statistical errors.
  • In the case of adjusted counts, the raw count should be explicitly listed immediately following the adjusted count as well as a brief description of the adjustment and a reference for the adjustment methodology. For example, if the adjusted number of deaths in the United States in 2020 is 3.4 million but the raw count of deaths was 3.3 million with 100,000 deaths added to adjust for unreported deaths of undocumented immigrants, the web pages and reports would say:

Total deaths (2020): 3.4 million (adjusted, raw count 3.3 million, unreported deaths of undocumented immigrants, adjustment methodology citation: Smith et al, MMWR Volume X, Number Y)

  • The distinction between the leading causes of death report “pneumonia and influenza” deaths, ~55,000 per year pre-pandemic, and the FluView website “pneumonia and influenza” deaths, ~188,000 per year pre-pandemic, should be clarified in the labels and legends for the graphics and prominently in the table of leading causes of death or immediately adjacent text. Statistical and systematic errors on these numbers should be provided in graphs and tables.
  • In general, where grossly different raw counts, adjusted counts, or estimates are presented in CDC documents and websites with the same name, semantically equivalent or nearly equivalent names such as “pneumonia and influenza” and “influenza and pneumonia,” clearly distinct names should be used instead, or the reasons for the gross difference in the values should be prominently listed in the graphs and tables or immediately adjacent text. It should be easy for the public, busy health professionals, policy makers and others to recognize and understand the differences.
  • CDC should provide results for different models for the same data with similar R2 values – coefficient of determination – to give the audience a quick sense of the systematic modeling errors – since there is no generally accepted methodology for estimating the 95% confidence level for the systematic modeling errors. See Figure 7 above for an example.
  • All mathematical models should be free and open source with associated data provided using commonly used free open-source scientific programming languages such as Python or R, made available on the CDC website, GitHub, and other popular sources. The models and data should be provided in a package form such that anyone with access to a standard MS Windows, Mac OS X, or Linux/Unix computer can easily download and run the analysis – similar to the package structure used by the GNU project, for example.
  • Specifically, the influenza virus deaths model should be provided to the public as code and data. The justification for the increase in the number of deaths attributed to influenza (~6,000 to ~55,000) should be presented in clear language with supporting numbers, such as the false positive and negative rates for the laboratory influenza deaths and general diagnosis of influenza in the absence of a positive lab test as well as in the code and data.
  • With respect to excess deaths tracking, include all major select causes of death, rather than just the thirteen (13) in the cause-specific excess deaths that CDC tracks, which currently account for about 2/3 of all deaths.
  • Include a Years of Lives Lost (YLL) display for COVID-19 deathsi and non-COVID-19 deaths, as well as excess deaths analysis, due to the higher granularity of YLL analysis when compared to excess deaths analysis. Explain the pros and cons of both analytical tools. Do the same for any future pandemics or health crises.
  • Adopt or develop a different algorithm or algorithms for tracking excess deaths which are mostly attributed to non-infectious causes such as heart attacks, cancer, and strokes. The Farrington/Noufaily algorithms were specifically developed as an early warning for often non-lethal infectious disease outbreaks such as salmonella. A medically-based model or models that incorporates population demographics such as the aging “baby boom” and evolving death rates broken down by age, sex, and possibly other factors where known is probably a better practice rather than simple empirical trend models such as the Noufaily algorithm.
  • Eliminate the zeroing procedure in calculating excess deaths, in which negative excess deaths in some categories are set to zero, rather than being added to the full excess deaths sum over all categories.
  • The anonymized data with causes of death as close to the actual data as possible, e.g. the actual death certificates, should be available on the CDC website in a simple accessible widely used format such as CSV (comma separated values) files. The code used to aggregate the data into summary data such as the FluView website data files should also be public.
  • The full Deaths Master File (DMF) including the actual names of the deceased persons and dates of death should be made available to the general public, independent researchers, and others. This is critical to independent verification of many numbers from the CDC, SSA, and US Census.
  • COVID-19-related deaths figures should be tracked based on year-specific age of death, rather than 10-year age ranges, as is currently the case.
  • CDC frequently changes the structure and layout of the CSV files/spreadsheets on their websites. The CDC should either (1) not do this or (2) provide easy conversion between different file formats with each new format so it is trivial for third parties to quickly adapt to the changes without writing additional code. CDC should provide a program or program in a free and open source language like R to convert between the formats.
  • The CDC and other agencies should be required to announce and solicit public comment for changes to case definitions, data collection rules, etc. for key public policy data such as the COVID-19 case definitions, death certification guidelines, and coding rules. Other government agencies have significantly more public participation than CDC, which is appropriate in a modern democracy.
  • Any practices and policies imposed in a public emergency, such as case definitions, definitions of measured quantities, data reporting practices, etc. imposed without public comment and review, should have an expiration date (e.g. sixty days) beyond which they must be subject to public review. Public comment, reviews, and cost/benefit analyses should happen during this emergency period.

Enacting these reforms should reduce the risk of serious errors, increase the quality and accuracy of CDC data and analyses, as well as any policies or CDC guidelines based on the data and analysis, and strengthen public confidence in the CDC and public health policies.

(C) 2021 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] How to Copy Data Tables into Working Python Code with EMACS Hotkey

https://odysee.com/@MathematicalSoftware:5/how_to_copy_data_tables_into_working_python_code_with_emacs_hotkey:5?

Alternative Video: BitChute NewTube ARCHIVE

Censored Video: YouTube

HOW TO COPY AND PASTE DATA TABLES INTO WORKING PYTHON CODE WITH EMACS

Video shows how to select, copy, and paste text data tables into working Python code with the Emacs text and code editor’s rectangle mode and an EMACS hotkey.

EMACS HOTKEY CODE SHOWN: http://wordpress.jmcgowan.com/wp/code-functions-to-convert-a-text-data-table-to-working-python-code-in-emacs/

The Emacs text and code editor has a built in rectangle mode for selecting, copying, pasting, and maniuplating rectangular regions in text since Emacs 24.

https://www.gnu.org/software/emacs/manual/html_node/emacs/Rectangles.html

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Locals (Video): https://mathematicalsoftware.locals.com/
Archive (Video): https://archive.org/details/@mathsoft

(C) 2021 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Code] Functions to Convert a Text Data Table to Working Python Code in EMACS

This is EMACS code and text editor LISP code to convert a space delimited text table into working Python code in EMACS. By default, it binds the python-table function below to the CTRL-= key sequence in EMACS for easy use. Add this code to your dot emacs EMACS startup file (~/.emacs). Restart EMACS to load the new dot emacs startup file.

Select the text data table in EMACS using rectangle-mark-mode — bound to CTRL-SPACEBAR by default — and press CTRL-= to convert the selected text data table to a Python NumPy fast numerical array definition. The emacs LISP function python-table automates the steps shown in the previous post “[Video] How to Copy and Paste Data Tables into Working Python Code with EMACS.”

(defun python-table-rows (inputStr)
  "Convert space delimited text table to working Python fast NumPy array definition code"
  (interactive "e")
  (setq head "table_name = np.array([\n")
  ;; replace thousands separator comma (,) with Python separator underscore (_)
  (setq temp1 (replace-regexp-in-string "," "_" inputStr))
  ;; enclose each row in [ (row) ],
;;  (setq temp2 (replace-regexp-in-string "\\(.*\\)" "[\\1]," temp1))
  (setq temp2 (replace-regexp-in-string "\\([a-zA-Z0-9_ \\.]*\\)" "[\\1]," temp1))
  ;; remove any spurious [],
  (setq temp2b (replace-regexp-in-string "\\[\\]," "" temp2))
  ;; convert repeated space delimeters to (comma)(space)
  (setq temp3 (replace-regexp-in-string " +" ", " temp2b))
  ;;  add ] to close list of lists, close paren ) to convert to numpy array
  (setq tail "])")
  ;; build entire Python code block
  (setq temp4 (concat head temp3))
  (setq temp5 (concat temp4 tail))
  ) ;; end defun python-table

(defun python-table ()
  " convert selected region with space separated text table to python code "
  (interactive)
  (message "running python-table") ;; progress message
  ;; use buffer-substring-no-properties to strip fonts etc.
  ;; get text from selected region and put in tmp variable
  (setq tmp (buffer-substring-no-properties (mark) (point)))
  ;; convert to Python Code and put in table variable
  (setq table (python-table-rows tmp))
  (message table) ;; progress message
  (delete-region (mark) (point))  ;; remove the region contents
  (insert table)  ;; replace with python code table definition
  ) ;; end defun ptable()

(global-set-key (kbd "C-=") 'python-table) ;; bind python-table to hot key

Use CTRL-X CTRL-F ~/.emacs RETURN to read in, display, and edit your dot emacs file in the EMACS editor.

How to Use

Add this code to your dot emacs file. Modify as appropriate if you know what you are doing.

Restart emacs.

Use the EMACS rectangle-mark-mode command — usually bound to CTRL-X SPACEBAR in EMACS — to select a rectangular text table as in the text below. Use Edit Menu | Copy or ESC-W to copy the text data table in EMACS.

This is an example of selecting, copying, and pasting a text table
into Python source code using the Emacs code and text editor.

Python is a popular programming language. With add on packages
such as NumPy, SciPy, and Matplotlib, it is a leading tool
for data analysis, scientific and numerical programming.

Demo Text Table
0.5      276
2.5      328
6.5      134
12.0     139
17.0   1,807 random notes here
22.0   3,342
29.5   5,340 commentary here
39.5   3,316
49.5   2,106
59.5   1,360 doodling here
69.5     562
79.5     270
89.5     120

This data is so great.

Three ways to select a rectangular text region in Emacs:

ESC-x rectangle-mark-mode
CTRL-X SPACE
SHIFT-(mouse drag)

URL: http://www.mathematical-software.com/

Use CTRL-y to paste the selected text table into Python code. Select the table and use CTRL-= to convert to working Python source code — a NumPy fast array definition with the values from the text table. The Python add-on packages NumPy, SciPy and MatPlotLib provide extensive numerical and statistical analysis functions and plotting.

(C) 2021 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] How to Copy and Paste Data Tables into Working Python Code with EMACS

https://odysee.com/@MathematicalSoftware:5/how_to_copy_and_paste_data_tables_into_working_python_code_with_emacs:7?

Other Free Video: ARCHIVE NewTube BitChute

Censored Video: YouTube

HOW TO COPY AND PASTE DATA TABLES INTO WORKING PYTHON CODE WITH EMACS

Video shows how to select, copy, and paste text data tables into working Python code with the Emacs text and code editor’s rectangle mode and emacs regular expressions (regexp).

The Emacs text and code editor has a built in rectangle mode for selecting, copying, pasting, and maniuplating rectangular regions in text since Emacs 24.

https://www.gnu.org/software/emacs/manual/html_node/emacs/Rectangles.html

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Locals (Video): https://mathematicalsoftware.locals.com/
Archive (Video): https://archive.org/details/@mathsoft

(C) 2021 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] How to Select, Copy, Cut and Paste Data Tables in LibreOffice Writer

Free Video Sites: BitChute NewTube Odysee

Video on how to select, copy, cut and paste data tables in LibreOffice Writer, a free, open-source “clone” of Microsoft Word.

Use ALT-(mouse drag) to select rectangular regions/columns in LibreOffice Writer. OR use Edit Menu | Selection Mode | Block Area

Use Table Menu | Convert | Text to Table or Table to Text to convert between simple text tables and LibreOffice Writer table objects.

Libre Office URL: https://www.libreoffice.org/

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Locals (Video): https://mathematicalsoftware.locals.com/
Archive (Video): https://archive.org/details/@mathsoft

(C) 2021 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] How to Extract Data Tables from a PDF

Alternative Video: BitChute NewTube Odysee

This is a short video on how to extract data tables from PDF documents
using the camelot Python package.

Camelot Project URL: https://pypi.org/project/camelot-py/

Simple example (-p page_number -f table_data_format lattice | stream command) :

  OS> camelot -p 43 -o output_file.csv -f csv lattice report_with_tables.pdf

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Locals (Video): https://mathematicalsoftware.locals.com/
Archive (Video): https://archive.org/details/@mathsoft

(C) 2021 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).