件の統計は復興庁の全国の避難者の数(所在都道府県別・所在施設別の数にあるが,このページはトップページから辿ることができず,検索からのみ到達できる.時系列でのデータは必須と思われるが,トップページから辿れるのは最新の情報のみであり,これは国民の利益に反する.
Power Query でフォルダから複数ファイルを一括インポートする
Power Query で,あるフォルダ内の同一構造のファイルを一括してインポートする機会は多い.M 言語は未開拓であるが,その一端に触れてみた.
EXCEL ブックであれ csv ファイルであれ,構造化されたデータという観点から見れば,ファイル形式などどうでも良い話である.この抽象化が理解できれば,Power Query への理解が一定程度進むのではないかと思う.
この記事はEXCEL VBA でフォルダ内のブックを開きデータを読み込むと対応する.
厚労省「地域ごとのまん延の状況に関する指標等」の PDF から Power BI Desktop でデータを抽出し EXCEL のグラフに表現する
新型コロナウイルスのパンデミック宣言以降,Twitter でフォローしているアカウントに自然と相互協調の動きがみられる.
厚労省が「地域ごとのまん延の状況に関する指標等」の公表を開始。
— にゃんこそば (@ShinagawaJP) 2020年4月23日
都道府県ごとの①確定患者数、②リンクが不明な患者数、③相談件数、④PCR検査の実施数…と、必要な情報を一通り網羅しています。
が、ファイルはまさかのPDF形式。ExcelかCSVも提供してくれれば…https://t.co/Ox5rU6m1Xo
このツイートから始まった一連のやりとりで,厚労省の発表した PDF からテーブルを抽出するくだりに注目した.
失礼します。今、マクロソフト Power BI デスクトップを使用したところ無事PDFを読み込めました。また、列のピボット解除という機能を使うことで、クロス集計表を添付のような集計用フォーマットに加工できます。 pic.twitter.com/FEV0SBSito
— Akira Takao (@modernexcel7) 2020年4月23日
今回はここを画像つきで実施してみた.
“厚労省「地域ごとのまん延の状況に関する指標等」の PDF から Power BI Desktop でデータを抽出し EXCEL のグラフに表現する” の続きを読む
総務省の都道府県・市区町村別統計表をデータクレンジングする
日本の人口統計は総務省が 5 年おきに行う国勢調査が元になっている.日本の市の人口順位をEXCELにダウンロードして散布図に描くでは日本全国の都市の人口増減率と人口の関係を時系列で流すとどう推移するか予測した.今回はその予測が実態と合っているか乖離しているかの検証を行う.
全国の地方気象台の所在地を調べる
気象庁のサクラ開花日のテキストファイルでは全国の地方気象台の所在地は明らかではなかった.ジオコーディングを始めるには所在地を正確にしておくことが重要だ.手始めに全国の地方気象台の所在地を確認することにした.
気象庁のサクラ開花日のテキストファイル
4月初旬はソメイヨシノの開花に心が躍る.古い歌にあるように,
世の中にたえてさくらのなかりせば春の心はのどけからまし
あっという間に散っていく様は日本人の心を捉えて離さない.この桜の開花日の予測は気象庁でも行われている.
桜だけではない.生物季節観測の情報では各種の植物,動物を観測しており,過去のデータを公表している.
時節柄,過去の桜開花日をダウンロードして検索しやすいようにしようと考えた.
ファイルは最初に置いておく.好きに使ってくれて構わない.
関連記事
テキストファイルから SQL Server に気象データをインポートする
PubMedで筋トレと炭水化物について論文検索してみた
前回に引き続き PubMed による検索.今回のテーマは増量であるが,増量に関しては検索結果は期待できない.
検索式は ((strength training) AND carbohydrate) AND systematic review である.これは詳細検索になる.結果は 31 件.そのうちめぼしい論文は以下の 3 編である.
- Resistance Training Prevents Muscle Loss Induced by Caloric Restriction in Obese Elderly Individuals: A Systematic Review and Meta-Analysis.
- Dietary Intake of Competitive Bodybuilders.
- The effect of exercise on the cardiovascular risk factors constituting the metabolic syndrome: a meta-analysis of controlled trials.
2 本目がそそるのだが,残念ながら有料論文だ.とりあえず要約だけコピペしてくる.
有料論文でも別ルートから全文が入手できる…かも
こういう時でも,諦めずに検索し続けると思わぬところから全文が手に入ったりする.まず試したいのはタイトルでの Google 検索だ.Google Scholar じゃないのか?と思うかも知れないが,通常の検索でよい.
論文特化型の検索だと公式の論文サイトからしか拾ってこないのだが,時々著者が自分のサイトで論文を公開してくれている場合がある. 今回はビンゴ!だった.
ResearchGate というサイトにあった.右上に Download full-text PDF というボタンがあるだろう?これがそうだ.
Dietary Intake of Competitive Bodybuilders.
BACKGROUND:
Competitive bodybuilders are well known for extreme physique traits and extremes in diet and trainingmanipulation to optimize lean mass and achieve a low body fat. Although many of the dietary dogmas in bodybuilding lack scientific scrutiny, a number, including timing and dosing of high biological value proteins across the day, have more recently been confirmed as effective by empirical research studies. A more comprehensive understanding of the dietary intakes of bodybuilders has the potential to uncover other dietary approaches, deserving of scientific investigation, with application to the wider sporting, and potential health contexts, where manipulation of physique traits is desired.
OBJECTIVE:
Our objective was to conduct a systematic review of dietary intake practices of competitive bodybuilders, evaluate the quality and currency of the existing literature, and identify research gaps to inform future studies.
METHODS:
A systematic search of electronic databases was conducted from the earliest record until March 2014. The search combined permutations of the terms ‘bodybuilding’, ‘dietary intake’, and ‘dietary supplement’. Included studies needed to report quantitative data (energy and macronutrients at a minimum) on habitual dietary intake of competitive bodybuilders.
RESULTS:
The 18 manuscripts meeting eligibility criteria reported on 385 participants (n = 62 women). Most studies were published in the 1980-1990s, with three published in the past 5 years. Study methodological quality was evaluated as poor. Energy intake ranged from 10 to 24 MJ/day for men and from 4 to 14 MJ/day for women. Protein intake ranged from 1.9 to 4.3 g/kg for men and from 0.8 to 2.8 g/kg for women. Intake of carbohydrate and fat was <6 g/kg/day and below 30% of energy, respectively. Carbohydrate intakes were below, and protein (in men) intakes were higher than, the current recommendations for strength athletes, with no consideration for exploration of macronutrient quality or distribution over the day. Energy intakes varied over different phases of preparation, typically being highest in the non-competition (>6 months from competition) or immediate post-competition period and lowest during competition preparation (≤6 months from competition) or competition week. The most commonly reported dietary supplements were protein powders/liquids and amino acids. The studies failed to provide details on rationale for different dietary intakes. The contribution of diet supplements was also often not reported. When supplements were reported, intakes of some micronutrients were excessive (~1000% of US Recommended Dietary Allowance) and above the tolerable upper limit.
CONCLUSION:
This review demonstrates that literature describing the dietary intake practices of competitive bodybuilders is dated and often of poor quality. Intake reporting required better specificity and details of the rationale underpinning the use. The review suggests that high-quality contemporary research is needed in this area, with the potential to uncover dietary strategies worthy of scientific exploration.
一つ興味深い記述がある.検索式だ. ‘bodybuilding’, ‘dietary intake’ and ‘dietary supplement’ で検索している.後で同じキーワードを適用してみることにしよう.
おっと,参考文献リストに randomised controlled trial が 2 編あるな.一応リンクを踏んでおこう. なになに,1 件目はチェックリスト作成について.これは直接関係なさそう.2 件目はどうだ?何かリンク先と PDF の内容がずれてる.これは PDF の方が正しい.タイトルは「過食中の体重増加,エネルギー消費量および体組成に及ぼす食餌たんぱく質含量の影響」だ.この論文もチェック対象に昇格させよう.
Effect of Dietary Protein Content on Weight Gain, Energy Expenditure, and Body Composition During Overeating
A Randomized Controlled Trial
Context
The role of diet composition in response to overeating and energy dissipation in humans is unclear.
Objective
To evaluate the effects of overconsumption of low, normal, and high protein diets on weight gain, energy expenditure, and body composition.
Design, Setting, and Participants
A single-blind, randomized controlled trial of 25 US healthy, weight-stable male and female volunteers, aged 18 to 35 years with a body mass index between 19 and 30. The first participant was admitted to the inpatient metabolic unit in June 2005 and the last in October 2007.
Intervention
After consuming a weight-stabilizing diet for 13 to 25 days, participants were randomized to diets containing 5% of energy from protein (low protein), 15% (normal protein), or 25% (high protein), which they were overfed during the last 8 weeks of their 10- to 12-week stay in the inpatient metabolic unit. Compared with energy intake during the weight stabilization period, the protein diets provided approximately 40% more energy intake, which corresponds to 954 kcal/d (95% CI, 884-1022 kcal/d).
Main Outcome Measures
Body composition was measured by dual-energy x-ray absorptiometry biweekly, resting energy expenditure was measured weekly by ventilated hood, and total energy expenditure by doubly labeled water prior to the overeating and weight stabilization periods and at weeks 7 to 8.
Results
Overeating produced significantly less weight gain in the low protein diet group (3.16 kg; 95% CI, 1.88-4.44 kg) compared with the normal protein diet group (6.05 kg; 95% CI, 4.84-7.26 kg) or the high protein diet group (6.51 kg; 95% CI, 5.23-7.79 kg) (P=.002). Body fat increased similarly in all 3 protein diet groups and represented 50% to more than 90% of the excess stored calories. Resting energy expenditure, total energy expenditure, and body protein did not increase during overfeeding with the low protein diet. In contrast, resting energy expenditure (normal protein diet: 160 kcal/d [95% CI, 102-218 kcal/d]; high protein diet: 227 kcal/d [95% CI, 165-289 kcal/d]) and body protein (lean body mass) (normal protein diet: 2.87 kg [95% CI, 2.11-3.62 kg]; high protein diet: 3.18 kg [95% CI, 2.37-3.98 kg]) increased significantly with the normal and high protein diets.
Conclusions
Among persons living in a controlled setting, calories alone account for the increase in fat; protein affected energy expenditure and storage of lean body mass, but not body fat storage.
系統的レビューから無作為化比較試験へ
調子に乗って別の検索式を試してみる.((strength training) AND carbohydrate) AND randomised controlled trial だとどうだろう?検索結果は 516 件に増えた.さすがにこれは全部チェックできないのでキーワードを加えて絞ることにする.
先程候補に上げたキーワードの一つ dietary intake を加えてみる.検索結果は 89 件に減った.これならタイトルチェックができそうだ.検索式は ((((strength training) AND carbohydrate) AND randomised controlled trial)) AND dietary intake となる.
キーワードを systematic review から randomised controlled trial に切り替えて何してるんだ?と思われたかも知れない.
これはエビデンスレベルの変更を行っている.系統的レビューが最もエビデンスレベルが高い.二番目に高いのが無作為化比較試験だ.系統的レビューであっても,元になる論文のレベルが低いと結果もあまり信頼できない.個人的なこだわりだが,質の低い系統的レビューよりも質の高い 1 本の無作為化比較試験の方が真実を射抜いている可能性がある.
ちょっとここでチートをしてみる.表示件数を 100 件に増やし,ブラウザの検索を使って carbohydrate というキーワードを検索する.該当は 18 件だが最初の 3 件は無関係なので無視.16 件目以降も無関係だ.
かなり興味深い検索結果だ. タイトルを見ているだけで関心のある論文に迫っているのが分かる.
- Effects of different macronutrient consumption following a resistance-training session on fat and carbohydrate metabolism.
- Minimal nutrition intervention with high-protein/low-carbohydrate and low-fat, nutrient-dense food supplement improves body composition and exercise benefits in overweight adults: A randomized controlled trial.
- Carbohydrate feeding during recovery alters the skeletal muscle metabolic response to repeated sessions of high-intensity interval exercise in humans.
- Increased p70s6k phosphorylation during intake of a protein-carbohydrate drink following resistance exercise in the fasted state.
Effects of different macronutrient consumption following a resistance-training session on fat and carbohydrate metabolism.
The effect of consuming meals of different macronutrient content on substrate oxidation following resistance exercise was examined in 9 resistance-trained men (26.2 +/- 2.4 years). Subjects completed 3 resistance exercise bouts of 8 exercises and 1 warm-up set (50% of 10 repetition maximum [RM]), which were followed by 3 sets of 10 repetitions (72.7 +/- 1.9% 10RM), with 60 seconds of rest between sets. Forty-five minutes after exercise, subjects consumed meals of high fat (HF, 37% carbohydrate, 18% protein, and 45% fat), high carbohydrate (HC, 79% carbohydrate, 20% protein, and 1% fat), or water (CON). Fat and carbohydrate oxidation were determined at 15-minute periods after meal consumption for 165 minutes. Blood was collected at preexercise (pre), premeal (0 minutes), and 15, 30, 45, 60, 90, 120, 150, and 180 minutes postmeal and was analyzed for insulin, glucose, triacylglycerols, and glycerol. There were no significant differences among the meal conditions for fat and carbohydrate oxidation. Insulin and glucose concentrations were significantly higher (p < 0.05) following HC at 15, 30, 45, 60, and 90 minutes compared to HF and CON. Triacylglycerol concentrations were significantly higher (p < 0.05) following HF at 90, 120, 150, and 180 minutes compared to HC and CON. Fat and carbohydrate oxidation were not affected by differences in macronutrient meal consumption after an acute bout of resistance training. Different macronutrient consumption does influence insulin, glucose, and triacylglycerol concentrations after resistance exercise.
Minimal nutrition intervention with high-protein/low-carbohydrate and low-fat, nutrient-dense food supplement improves body composition and exercise benefits in overweight adults: A randomized controlled trial.
BACKGROUND:
Exercise and high-protein/reduced-carbohydrate and -fat diets have each been shown separately, or in combination with an energy-restricted diet to improve body composition and health in sedentary, overweight (BMI > 25) adults. The current study, instead, examined the physiological response to 10 weeks of combined aerobic and resistance exercise (EX) versus exercise + minimal nutrition intervention designed to alter the macronutrient profile, in the absence of energy restriction, using a commercially available high-protein/low-carbohydrate and low-fat, nutrient-dense food supplement (EXFS); versus control (CON).
METHODS:
Thirty-eight previously sedentary, overweight subjects (female = 19; male = 19) were randomly assigned to either CON (n = 10), EX (n = 14) or EXFS (n = 14). EX and EXFS participated in supervised resistance and endurance training (2x and 3x/wk, respectively); EXFS consumed 1 shake/d (weeks 1 and 2) and 2 shakes/d (weeks 3-10).
RESULTS:
EXFS significantly decreased total energy, carbohydrate and fat intake (-14.4%, -27.2% and -26.7%, respectively; p < 0.017), and increased protein and fiber intake (+52.1% and +21.2%, respectively; p < 0.017). EX and EXFS significantly decreased fat mass (-4.6% and -9.3%, respectively; p < 0.017), with a greater (p < 0.05) decrease in EXFS than EX and CON. Muscle mass increase only reached significance in EXFS (+2.3%; p < 0.017), which was greater (p < 0.05) than CON but not EX (+1.1%). Relative VO2max improved in both exercise groups (EX = +5.0% and EXFS = +7.9%; p < 0.017); however, only EXFS significantly improved absolute VO2max (+6.2%; p = 0.001). Time-to-exhaustion during treadmill testing increased in EX (+9.8%) but was significantly less (p < 0.05) than in EXFS (+21.2%). Total cholesterol and LDL decreased only in the EXFS (-12.0% and -13.3%, respectively; p < 0.017). Total cholesterol-to-HDL ratio, however, decreased significantly (p < 0.017) in both exercise groups.
CONCLUSION:
Absent energy restriction or other dietary controls, provision of a high-protein/low-carbohydrate and -fat, nutrient-dense food supplement significantly, 1) modified ad libitum macronutrient and energy intake (behavior effect), 2) improved physiological adaptations to exercise (metabolic advantage), and 3) reduced the variability of individual responses for fat mass, muscle mass and time-to-exhaustion – all three variables improving in 100% of EXFS subjects.
Carbohydrate feeding during recovery alters the skeletal muscle metabolic response to repeated sessions of high-intensity interval exercise in humans.
Exercise training under conditions of reduced carbohydrate (CHO) availability has been reported to augment gains in skeletal muscle oxidative capacity; however, the underlying mechanisms are unclear. We examined the effect of manipulating CHO intake on the acute metabolic response to high-intensity interval exercise, including signaling cascades linked to mitochondrial biogenesis. Ten men performed two trials in random order separated by >or=1 wk. Each trial consisted of a morning (AM) and afternoon (PM) training session (5 x 4 min cycling at approximately 90-95% of heart rate reserve) separated by 3 h of recovery during which subjects ingested a high-CHO drink (HI-HI) or nonenergetic placebo (HI-LO) before PM exercise. Biopsies (vastus lateralis) revealed that muscle phosphocreatine and ATP content were similar after AM exercise but decreased to a greater extent during PM exercise in HI-LO vs. HI-HI. Phosphorylation of p38 mitogen-activated protein kinase (MAPK) and AMP-activated protein kinase (AMPK) increased approximately 4-fold and 2-fold, respectively, during AM exercise with no difference between conditions. After PM exercise, p38 MAPK phosphorylation was higher in HI-LO vs. HI-HI, whereas AMPK was not different between conditions. Peroxisome proliferator-activated receptor gamma coactivator 1-alpha (PGC-1 alpha) gene expression increased approximately 8-fold during recovery from AM exercise and remained elevated during PM exercise with no differences between conditions. Cytochrome oxidase subunit 4 (COXIV) mRNA was also elevated 3 h after AM exercise, with no difference between conditions. These data provide evidence that p38 MAPK is a nutrient-sensitive signaling molecule that could be involved in the altered skeletal muscle adaptive response reported after exercise training under conditions of restricted CHO intake, but further research is required to confirm this hypothesis.
Increased p70s6k phosphorylation during intake of a protein-carbohydrate drink following resistance exercise in the fasted state.
The present study aimed at comparing the responses of myogenic regulatory factors and signaling pathways involved in muscle protein synthesis after a resistance training session performed in either the fasted or fed state. According to a randomized crossover study design, six young male subjects participated in two experimental sessions separated by 3 weeks. In each session, they performed a standardized resistance training. After the sessions, they received during a 4-h recovery period 6 ml/kg b.w. h of a solution containing carbohydrates (50 g/l), protein hydrolysate (33 g/l), and leucine (16.6 g/l). On one occasion, the resistance exercise session was performed after the intake of a carbohydrate-rich breakfast (B), whereas in the other session they remained fasted (F). Needle biopsies from m. vastus lateralis were obtained before (Rest), and 1 h (+1h) and 4 h (+4h) after exercise. Myogenin, MRF4, and MyoD1 mRNA contents were determined by RT-PCR. Phosphorylation of PKB (protein kinase B), GSK3, p70(s6k) (p70 ribosomal S6 kinase), eIF2B, eEF2 (eukaryotic elongation factor 2), ERK1/2, and p38 was measured via western blotting. Compared with F, the pre-exercise phosphorylation states of PKB and p70(s6k) were higher in B, whereas those of eIF2B and eEF2 were lower. During recovery, the phosphorylation state of p70(s6k) was lower in B than in F (p = 0.02). There were no differences in basal mRNA contents between B and F. However, compared with F at +1h, MyoD1 and MRF4 mRNA contents were lower in B (p < 0.05). Our results indicate that prior fasting may stimulate the intramyocellular anabolic response to ingestion of a carbohydrate/protein/leucine mixture following a heavy resistance training session.
Twitter でフォローしていたアカウントが興味深い論文を紹介してくれていた.
Carbohydrate restriction: Friend or foe of resistance-based exercise performance?
It is commonly accepted that adequate carbohydrate availability is necessary for optimal endurance performance. However, for strength- and physique-based athletes, sports nutrition research and recommendations have focused on protein ingestion, with far less attention given to carbohydrates. Varying resistance exercise protocols, such as differences in intensity, volume, and intraset rest prescriptions between strength-training and physique-training goals elicit different metabolic responses, which may necessitate different carbohydrate needs. The results of several acute and chronic training studies suggest that although severe carbohydrate restriction may not impair strength adaptations during a resistance training program, consuming an adequate amount of carbohydrate in the days leading up to testing may enhance maximal strength and strength–endurance performance. Although several molecular studies demonstrate no additive increases in postexercise mammalian target of rapamycin 1 phosphorylation with carbohydrate and protein compared with protein ingestion alone, the effects of chronic resistance training with carbohydrate restriction on muscle hypertrophy are conflicting and require further research to determine a minimal carbohydrate threshold necessary to optimize muscle hypertrophy. This review summarizes the current knowledge regarding carbohydrate availability and resistance training outcomes and poses new research questions that will better help guide carbohydrate recommendations for strength and physique athletes. In addition, given that success in physique sports is based on subjective appearance, and not objective physical performance, we also review the effects of subchronic carbohydrate ingestion during contest preparation on aesthetic appearance.
残念ながら,この論文は公開後日が浅いこともあって全文を先程のルートで公開してくれている訳ではなかった.アカウント取得の時点でつまづいている.
この記事の最初に紹介した論文も実はいい線行っている.前回の減量に関する記事に紹介したほうがよかったかも知れない.これから精読に入ろう.読み込めたらまた紹介する.
追記
炭水化物または蛋白質,筋トレ,系統的レビュー,メタ解析から糖尿病と癌を削り取った検索式は ((((((protein) OR carbohydrate) AND strength training) AND systematic review) AND meta analysis) NOT diabetes) NOT cancer となる.この検索結果は 20 件.これまで見てきた論文が半分近くある.
減量に関する論文検索
今,減量の仕上げにかかっているところである.巷には減量に関するノウハウが溢れているが,アカデミックな裏付けが欲しいと考え,文献検索を行った.
“減量に関する論文検索” の続きを読む日本標準食品成分表2015をダウンロードし,データクレンジングを行う
文部科学省には日本標準食品成分表のデータがある.食品の栄養素の計算に用いられるデータで,食品成分データベースやフィットネス,ダイエット関連アプリのデータベースの基本となっているものである.
このデータは 5 年ごとに更新されており,最新のデータは 2015 年のものである.次の更新は 2020 年の予定である.今回の記事ではこのデータをダウンロードし,クレンジングを行う.
“日本標準食品成分表2015をダウンロードし,データクレンジングを行う” の続きを読むテキストファイルから SQL Server に気象データをインポートする
データベースにテキストファイルをインポートしたいというニーズは多い.今回は csv ファイルから SQL Server にデータをインポートしたので備忘録として公開する.
“テキストファイルから SQL Server に気象データをインポートする” の続きを読む