| python |
Pythonタグが付けられた新着投稿 - Qiita |
OpenpyxlでPythonからExcelファイルを操作 |
https://qiita.com/Naoki_kkc/items/9685a15b5a561af727ce
|
インストール必要に応じて仮想環境を有効化することpythonmpipinstallopenpyxlPythonでパッケージ読み込みNameErrornameopenpyxlisnotdefinedとか出たらこれをやるimportopenpyxlワークブックを開くカレントディレクトリに「samplexlsx」があることを想定workbookopenpyxlloadworkbooksamplexlsxシートを開く上記で開いたワークブックに「Sheet」シートがあることを想定シート名はケースセンシティブなので注意sheetworkbookSheet単一セルを選択上記で開いたシートの「A」セルを選択cellAsheetAセルから情報を取得上記で開いたセルを対象に実行入力値cellAvaluecellAvalueprintcellAvalueハイパーリンクcellAlinkcellAhyperlinktargetprintcellAlinkフォントcellAfontcellAfontprintcellAfontセルに情報を設定上記で開いたセルを対象に実行後述の保存を行わないと反映されないので注意入力値cellAvalueQiitaハイパーリンクcellAhyperlinktarget列の追加上記で開いたシートを対象に実行後述の保存を行わないと反映されないので注意A列が。 |
2021-05-24 02:05:16 |
| Program |
[全てのタグ]の新着質問一覧｜teratail（テラテイル） |
2台のEC2を用意して1台セッションマネージャーから入ってもう一台のEC2にSSH接続をしたい |
https://teratail.com/questions/339978?rss=all
|
台のECを用意して台セッションマネージャーから入ってもう一台のECにSSH接続をしたい困っていること・前提現在台のセッションマネージャーを使ってECに接続をしたのですがそこからもう一台のECにSSH接続をしたのですがやり方がわかりませんSessionnbspManagerを使ったEC内でsshiltキーペアgtecuserltパブリックIPアドレスgtしましたところWarningIdentityfileltキーペアgtnotaccessibleNosuchfileordirectoryPermissiondeniedpublickeygssapikeyexgssapiwithmic上記のようにディレクトリがないと返されました。 |
2021-05-24 02:43:36 |
| Program |
[全てのタグ]の新着質問一覧｜teratail（テラテイル） |
リストの中から、最初に見つかった負の値を表示したい |
https://teratail.com/questions/339977?rss=all
|
break |
2021-05-24 02:23:42 |
| Program |
[全てのタグ]の新着質問一覧｜teratail（テラテイル） |
Unityのメモリ領域のSystem.Byte［］への対処法について |
https://teratail.com/questions/339976?rss=all
|
Unityのメモリ領域のSystemByteへの対処法について前提・実現したいことメモリ領域を圧迫するSystemByteが発生する原因を知り、メモリ使用量を低減したい。 |
2021-05-24 02:10:16 |
| 海外TECH |
DEV Community |
As a man in tech I stand for EQUALITY |
https://dev.to/gac/as-a-man-in-tech-i-stand-for-equality-11o8
|
As a man in tech I stand for EQUALITYThe topic that I m going to cover today is a bit different from what I usually write about but I felt the need to express my opinion on this subject because even though we are living in we are still acting like we are in the stone age and even than it shouldn t have been acceptable Ever since I got into the tech scene back in the one thing that stood out the most to me was the lack of diversity and equality in this field especially for people that identify as women I follow a lot of great content creators blog tutorial writers video makers live streamers ーmany of whom identify as women ーwho are exposed to so many inappropriate comments about their looks or their skill levels See just some of countless examples below Ali Spittel aspittel it s wild to me how guys with learning how to code in their bio get treated like experts and i get python resources sent to me lol PM May ️Salma whitepnthr A comment from a viewer on stream last night whilst I was building unbreak tech “wHy ArE yOu So ObSeSsEd WiTh EqUaLiTy Ask yourself why you refuse to acknowledge there s a problem And then act PM May Some might find it funny or amusing to leave comments on their posts or in live streams such as hey baby or you re sexy which just demotes their value as a person and can seriously ruin their day but also have a long standing effects and for what You getting a giggle out of their reaction Getting to feel superior STOP You DO NOT have the privilege or the right to speak that way to anyone You are not entitled to flirt with women You are not entitled to comment on a woman s appearance You are not entitled to a damn thing Keep your shitty little comments to yourself Who is to blame for this Me I am I ve watched this abuse happen and did nothing I was the problem I will not sit idle I will act People deserve to be safe Now the hard question How about you |
2021-05-23 17:42:17 |
| 海外TECH |
DEV Community |
Weekly Digest 20/2021 - Top of the Week |
https://dev.to/worldindev/weekly-digest-20-2021-5f27
|
Weekly Digest Top of the WeekWelcome to my Weekly Digest which is the last one of May This weekly digest contains a lot of interesting and inspiring articles videos tweets podcasts and designs I consumed during this week GiveawayWe are giving away any course you need on Udemy Any price any course To enter you have to do the following React to this post️Subscribe to our newsletterYou will receive our articles directly to your inbox Interesting articles to read Frustrating Design Patterns Mega Dropdown Hover MenusDo we need mega dropdown hover menus in Probably not Let s explore things to keep in mind when designing and building a mega dropdown alternatives to hover menus and fine details for designing a better UX Frustrating Design Patterns Mega Dropdown Hover Menus Smashing Magazine How to use Testing Library to test StorybookYann Braga introduces storybook testing react a new library that makes Storybook even more useful by helping you to reuse stories in Testing Library How to efficiently reuse stories in your React tests Advanced CSS Animation Using cubic bezier When dealing with complex CSS animations there is a tendency to create expansive keyframes with lots of declarations There are a couple of tricks though that I want to talk about that might help make things easier while staying in vanilla CSS Advanced CSS Animation Using cubic bezier CSS Tricks How to talk to your company about sponsoring an open source projectOpen source sustainability is a topic that is just starting to get the attention that it deserves So much of the technology sector is run on software that can be used for free without any further obligation How to talk to your company about sponsoring an open source project of developers get this line CSS quiz wrongWithout trying this out what background do you expect lt div gt to have of developers get this line CSS quiz wrong Some great videos I watched this week The Find Command My Favorite UNIX Command by Colt Steele Chrome DevTools for designersIn this Session you ll learn about the various design tooling tips how to diagnose common design issues with Chrome DevTools as well as some helpful steps to debug them by Jecelyn Yeen and Adam Argyle The new responsive Web design in a component driven worldThe web community is entering into a new era of responsive design and shifting our perspectives on what it means With user preference queries container queries and other form factor queries on the horizon we ll soon have the tools to create responsive designs far beyond what querying the global viewport allows by Una Kravets Page performance after loadWeb performance optimization tends to focus on initial page load because it s the first major landmark where you can lose your audience However the user experience of highly interactive pages is often governed by post load characteristics by Jason Miller and Surma Sneaking a Peek at Tailwind CSS vIn this video we look at a few new features coming in Tailwind CSS v and how you can start playing with them yourself using our canary builds by Tailwind Labs Useful GitHub repositories git secretsPrevents you from committing secrets and credentials into git repositories awslabs git secrets Prevents you from committing secrets and credentials into git repositories git secretsPrevents you from committing passwords and other sensitive information to a git repository ContentsSynopsisDescriptionInstalling git secrets nix Linux macOS WindowsHomebrew for macOS users Advanced configurationBefore making public a repositoryOptionsOperation ModesOptions for installOptions for scanOptions for listOptions for addOptions for register awsOptions for aws providerOptions for add providerDefining prohibited patternsIgnoring false positivesSecret providersExample walkthroughSkipping validationAboutSynopsisgit secrets scan r recursive cached no index untracked lt files gt git secrets scan historygit secrets install f force lt target directory gt git secrets list global git secrets add a allowed l literal global lt pattern amp gtgit secrets add provider global lt command gt arguments git secrets register aws global git secrets aws provider lt credentials file gt Descriptiongit secrets scans commits commit messages and no ff merges toprevent adding secrets into your git repositories If a commitcommit message or any commit in a no ff merge history matches one ofyour configured prohibited regular expression… View on GitHub SQLFluffA SQL linter and auto formatter for Humans sqlfluff sqlfluff A SQL linter and auto formatter for Humans The SQL Linter for humansSQLFluff is a dialect flexible and configurable SQL linter Designed with ELT applications in mind SQLFluff also works with jinja templating and dbt SQLFluff will auto fix most linting errors allowing you to focus your time on what matters Getting StartedTo get started install the package and run sqlfluff lint or sqlfluff fix pip install sqlfluff echo SELECT a b FROM tbl gt test sql sqlfluff lint test sql test sql FAILL P L Single indentation uses a number of spaces not a multiple of L P L Operators should be surrounded by a single space unless at the start end of a lineL P L Unnecessary trailing whitespaceYou can also have a play using SQLFluff online For full CLI usage and… View on GitHub Readme soReadme so is an online editor to help developers make readmes for their project katherinepeterson readme so readme soReadme so is an online editor to help developers make readmes for their project Link to production site readme soFeaturesChoose from list of sections to add to your readmeEdit the contents of each sectionDrag and drop to rearrange sectionsDownload your readme fileContributingContributions are always welcome See CONTRIBUTING md for ways to get started Tech StackNext jsTailwindCSSdnd kitreact markdownRunning the Dev ServerTo run the dev server run npm run dev and navigate to localhost FeedbackFeedback is appreciated Reach out on Twitter or submit a new issue LicenseMITThis readme was created with readme so View on GitHub Social AnalyzerAPI CLI amp Web App for analyzing amp finding a person s profile across social media websites Detections are updated regularly qeeqbox social analyzer API CLI amp Web App for analyzing amp finding a person s profile across social media websites Detections are updated regularly Social Analyzer API CLI amp Web App for analyzing amp finding a person s profile across social media websites It includes different string analysis and detection modules you can choose which combination of modules to use during the investigation process The detection modules utilize a rating mechanism based on different detection techniques which produces a rate value that starts from to No Maybe Yes This module intended to have less false positive and it s documented in this Wiki linkThe analysis and public extracted information from this OSINT tool could help in investigating profiles related to suspicious or malicious activities such as cyberbullying cybergrooming cyberstalking and spreading misinformation This project is currently used by some law enforcement agencies in countries where resources are limited UpdateSave the GUI analysis output as JSON file has been implemented Users request For issues and questions related… View on GitHub dribbble shots Chef Finder Appby Mitesh Samal Mobile Finance App Concept Designby Julius Branding Crypter Componentby Tran Mau Tri Tam Food delivery appby Anton Anoshko GSーProjectby Alexander Laguta Smart Home App Designby Abdullah Mubin Tweets Erik Rasmussen erikras BeatlesInCode AM May Marko Denic denicmarko JavaScript tip Use the window print to create a print page functionality PM May Telmo Goncalves telmo My latest creation A playlist for developers AM May Vincent Voyer vvoyer You can now generate uuids v in Node js without using any dependency nodejs org en blog releas… PM May Addy Osmani addyosmani Miss Google Reader Chrome is experimenting with a native Follow feature for sites with an RSS feed Surfacing them in the New Tab Page could help discover new posts and encourage more sites to invest in a good RSS experience for all RSS readers goo gle chfollow PM May Devon Govett devongovett Super excited to announce Parcel s new JavaScript compiler Up to x fasterWritten in Rustx faster transpilation via SWCImproved scope hoistingExcited to build on this foundation and improve performance even further Details v parceljs org blog beta PM May Picked Pens lifeMeditationby Sophia Podcasts worth listening Smashing Podcast What is VisBug We re talking about VisBug What is it and how is it different from the array of options already found in Chrome DevTools Drew McLellan talks to its creator Adam Argyle to find out Minutes with Kent TypeScript is testing Syntax Stylin the Unstylables Tools and Resources Learn CSSAn evergreen CSS course and reference to level up your web styling expertise Learn CSS Fluid typographyCreate text that scales with the window size so that your headings look great on any screen Fluid TypographyThank you for reading talk to you next week and stay safe Make sure to subscribe to our newsletter to receive our weekly recap directly on your email and react to this post to automatically participate in our giveaway If you would like to join our discussions you can find us on Discord |
2021-05-23 17:02:35 |
| ニュース |
BBC News - Home |
Italy cable car fall: 13 dead after accident near Lake Maggiore |
https://www.bbc.co.uk/news/world-europe-57219737
|
italy |
2021-05-23 17:18:09 |
| ニュース |
BBC News - Home |
Covid: UK passes 60m jabs milestone after 762,000 in a day |
https://www.bbc.co.uk/news/uk-57221506
|
chief |
2021-05-23 17:54:42 |
| ニュース |
BBC News - Home |
Coronavirus: Patel denies No 10 pursued herd immunity policy |
https://www.bbc.co.uk/news/uk-politics-57217740
|
cummings |
2021-05-23 17:16:02 |
| ニュース |
BBC News - Home |
Belarus diverts Ryanair flight to arrest journalist, says opposition |
https://www.bbc.co.uk/news/world-europe-57219860
|
minsk |
2021-05-23 17:31:24 |
| ニュース |
BBC News - Home |
Scotland's lord advocate and solicitor general resign |
https://www.bbc.co.uk/news/uk-scotland-57221516
|
alison |
2021-05-23 17:51:15 |
| ニュース |
BBC News - Home |
Liverpool 2-0 Crystal Palace: Sadio Mane double seals Champions League qualification |
https://www.bbc.co.uk/sport/football/57132111
|
anfield |
2021-05-23 17:41:38 |
| ニュース |
BBC News - Home |
Aston Villa 2-1 Chelsea: Blues lose but seal top-four finish |
https://www.bbc.co.uk/sport/football/57132104
|
Aston Villa Chelsea Blues lose but seal top four finishChelsea secure a place in next season s Champions League despite losing to Aston Villa Thomas Tuchel s side sealing a top four place ahead of Leicester City |
2021-05-23 17:54:19 |
| ニュース |
BBC News - Home |
Leicester miss out on Champions League after Schmeichel own goal triggers late collapse |
https://www.bbc.co.uk/sport/football/57132108
|
Leicester miss out on Champions League after Schmeichel own goal triggers late collapseLeicester are denied a place in the Champions League for the second season running with Gareth Bale scoring two late goals to give Tottenham victory on a dramatic final day in the Premier League |
2021-05-23 17:48:02 |
| 北海道 |
北海道新聞 |
「仕事はホテルで」客室を時間貸し 「札幌ビュー」が新事業 |
https://www.hokkaido-np.co.jp/article/547123/
|
大通公園 |
2021-05-24 02:02:35 |
| 海外TECH |
reddit |
Royal Never Give Up vs. DWG KIA / MSI 2021 - Final / Post-Match Discussion |
https://www.reddit.com/r/leagueoflegends/comments/njcfp0/royal_never_give_up_vs_dwg_kia_msi_2021_final/
|
Royal Never Give Up vs DWG KIA MSI Final Post Match DiscussionMSI PLAYOFFS Official page Leaguepedia Liquipedia Live Discussion Eventvods com New to LoL Royal Never Give Up DWG KIA Congratulations to Royal Never Give Up on claiming the MSI title Finals MVP GALA RNG Leaguepedia Liquipedia Website Twitter Facebook YouTube DK Leaguepedia Liquipedia Website Twitter Facebook YouTube MATCH RNG vs DK Winner Royal Never Give Up in m Match History Bans Bans G K T D B RNG zoe senna varus syndra viktor k M H O H I I E B E B DK thresh renekton lee sin orianna nocturne k None RNG vs DK Xiaohu gragas TOP sion Khan Wei udyr JNG morgana Canyon Cryin lucian MID akali ShowMaker GALA kaisa BOT tristana Ghost Ming nautilus SUP leona BeryL MATCH DK vs RNG Winner DWG KIA in m Match History Bans Bans G K T D B DK thresh lucian varus nautilus ryze k H I I B RNG zoe senna renekton sylas syndra k O H C DK vs RNG Khan lee sin TOP jayce Xiaohu Canyon morgana JNG udyr Wei ShowMaker xerath MID orianna Cryin Ghost tristana BOT kaisa GALA BeryL leona SUP rell Ming MATCH RNG vs DK Winner Royal Never Give Up in m Match History Bans Bans G K T D B RNG zoe senna varus gangplank sion k H H M B M B DK renekton lee sin lucian nautilus orianna k I O M RNG vs DK Xiaohu gnar TOP nocturne Khan Wei udyr JNG morgana Canyon Cryin ryze MID syndra ShowMaker GALA kaisa BOT jinx Ghost Ming leona SUP thresh BeryL MATCH DK vs RNG Winner DWG KIA in m Match History Bans Bans G K T D B DK thresh lucian varus nautilus orianna k C H I O B O RNG zoe senna lee sin gnar sylas k H DK vs RNG Khan aatrox TOP gragas Xiaohu Canyon nidalee JNG udyr Wei ShowMaker renekton MID ryze Cryin Ghost tristana BOT kaisa GALA BeryL rell SUP leona Ming MATCH RNG vs DK Winner Royal Never Give Up in m Match History Bans Bans G K T D B RNG zoe senna thresh sylas gnar k H O H B C DK renekton lee sin lucian nautilus rell k I RNG vs DK Xiaohu gragas TOP aatrox Khan Wei udyr JNG rumble Canyon Cryin nocturne MID jayce ShowMaker GALA kaisa BOT varus Ghost Ming leona SUP tahmkench BeryL Patch This thread was created by the Post Match Team submitted by u adzr to r leagueoflegends link comments |
2021-05-23 17:25:04 |
コメント
コメントを投稿