Power Query で，あるフォルダ内の同一構造のファイルを一括してインポートする機会は多い．M 言語は未開拓であるが，その一端に触れてみた．
EXCEL ブックであれ csv ファイルであれ，構造化されたデータという観点から見れば，ファイル形式などどうでも良い話である．この抽象化が理解できれば，Power Query への理解が一定程度進むのではないかと思う．
この記事はEXCEL VBA でフォルダ内のブックを開きデータを読み込むと対応する．
厚労省が「地域ごとのまん延の状況に関する指標等」の公表を開始。— にゃんこそば (@ShinagawaJP) 2020年4月23日
このツイートから始まった一連のやりとりで，厚労省の発表した PDF からテーブルを抽出するくだりに注目した．
失礼します。今、マクロソフト Power BI デスクトップを使用したところ無事PDFを読み込めました。また、列のピボット解除という機能を使うことで、クロス集計表を添付のような集計用フォーマットに加工できます。 pic.twitter.com/FEV0SBSito— Akira Takao (@modernexcel7) 2020年4月23日
前回に引き続き PubMed による検索．今回のテーマは増量であるが，増量に関しては検索結果は期待できない．
検索式は ((strength training) AND carbohydrate) AND systematic review である．これは詳細検索になる．結果は 31 件．そのうちめぼしい論文は以下の 3 編である．
こういう時でも，諦めずに検索し続けると思わぬところから全文が手に入ったりする．まず試したいのはタイトルでの Google 検索だ．Google Scholar じゃないのか？と思うかも知れないが，通常の検索でよい．
ResearchGate というサイトにあった．右上に Download full-text PDF というボタンがあるだろう？これがそうだ．
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.
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.
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.
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.
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 の方が正しい．タイトルは「過食中の体重増加，エネルギー消費量および体組成に及ぼす食餌たんぱく質含量の影響」だ．この論文もチェック対象に昇格させよう．
The role of diet composition in response to overeating and energy dissipation in humans is unclear.
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.
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.
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.
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 件目以降も無関係だ．
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.
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).
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).
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.
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.
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.
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.
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 件．これまで見てきた論文が半分近くある．
データベースにテキストファイルをインポートしたいというニーズは多い．今回は csv ファイルから SQL Server にデータをインポートしたので備忘録として公開する．“テキストファイルから SQL Server に気象データをインポートする” の続きを読む