投稿時間:2023-01-12 21:27:24 RSSフィード2023-01-12 21:00 分まとめ(29件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	気になる、記になる…	Apple、99ドルの安価な｢AirPods｣を開発中か	https://taisy0.com/2023/01/12/166995.html	airpods	2023-01-12 11:20:07
IT	気になる、記になる…	au、｢DAZN｣がセットになった料金プランを3月1日より値上げへ	https://taisy0.com/2023/01/12/166993.html	daznglobal	2023-01-12 11:04:57
IT	ITmedia 総合記事一覧	[ITmedia PC USER] Intelが「第4世代Xeonスケーラブルプロセッサ」を正式発表　後から機能を拡張できる「Intel On Demand」対応モデルも	https://www.itmedia.co.jp/pcuser/articles/2301/12/news180.html	ITmediaPCUSERIntelが「第世代Xeonスケーラブルプロセッサ」を正式発表後から機能を拡張できる「IntelOnDemand」対応モデルもIntelが、データセンターサーバHPC向けCPU「Xeonスケーラブルプロセッサ」の第世代製品を正式に発表した。	2023-01-12 20:45:00
IT	ITmedia 総合記事一覧	[ITmedia News] コロプラ、月1万円のインフレ手当支給　23年12月まで	https://www.itmedia.co.jp/news/articles/2301/12/news183.html	itmedia	2023-01-12 20:15:00
js	JavaScriptタグが付けられた新着投稿 - Qiita	paizaラーニング レベルアップ問題集 Aランクレベルアップメニュー JavaScript 重みあり有向グラフの隣接行列と隣接リスト	https://qiita.com/ZampieriIsa/items/ed72c28cbb096b42a8bf	javascript	2023-01-12 20:34:38
js	JavaScriptタグが付けられた新着投稿 - Qiita	paizaラーニング レベルアップ問題集 Aランクレベルアップメニュー JavaScript 有向グラフの隣接行列と隣接リスト	https://qiita.com/ZampieriIsa/items/d84a3e1b1fbc915adab8	javascript	2023-01-12 20:24:00
js	JavaScriptタグが付けられた新着投稿 - Qiita	paizaラーニング レベルアップ問題集 Aランクレベルアップメニュー JavaScript 隣接リスト	https://qiita.com/ZampieriIsa/items/2e14382b44163167475b	javascript	2023-01-12 20:20:17
js	JavaScriptタグが付けられた新着投稿 - Qiita	paizaラーニング レベルアップ問題集 Aランクレベルアップメニュー JavaScript 隣接行列	https://qiita.com/ZampieriIsa/items/a55d00e67eb2a1042c05	javascript	2023-01-12 20:08:41
技術ブログ	Developers.IO	AWS SAMでデプロイ済みのAPI Gatewayの不要な「Stage」を削除する with OpenAPI	https://dev.classmethod.jp/articles/aws-sam-delete-deploy-unused-stage-with-openapi/	apigateway	2023-01-12 11:43:59
海外TECH	MakeUseOf	Refurbished Mac vs. Used Mac: Which Is Better?	https://www.makeuseof.com/refurbished-vs-used-mac/	refurbished	2023-01-12 11:45:17
海外TECH	MakeUseOf	Meta Fined by Europe PLUS How to Buy an iPhone and Switch from Android	https://www.makeuseof.com/meta-fined-by-europe-plus-how-to-buy-an-iphone-and-switch-from-android/	android	2023-01-12 11:30:15
海外TECH	MakeUseOf	8 Things the Apple Watch Can Do Without Your iPhone Nearby	https://www.makeuseof.com/things-apple-watch-can-do-without-iphone/	Things the Apple Watch Can Do Without Your iPhone NearbyYour Apple Watch may be a companion device for your iPhone but you can use it independently to do many things like the ones we ve listed here	2023-01-12 11:30:15
海外TECH	DEV Community	Understanding the basics and advanced concepts of RDBMS and SQL for data science and analysis	https://dev.to/anurag629/understanding-the-basics-and-advanced-concepts-of-rdbms-and-sql-for-data-science-and-analysis-5h4l	Understanding the basics and advanced concepts of RDBMS and SQL for data science and analysis Day of Days Data Science Bootcamp from noob to expert GitHub link Complete Data Science Bootcamp Main Post Complete Data Science Bootcamp Recap Day Yesterday we have studied in detail about Data Visualization using matplotlib and seaborn in Python Let s StartA DBMS Database Management System is a software application that interacts with end users other applications and the database itself to capture and analyze the data It is a tool that allows data scientists to store manage and retrieve large amounts of structured and unstructured data There are different types of DBMSs such as relational databases NoSQL databases and graph databases Relational databases such as MySQL and PostgreSQL use a structured query language SQL to manage data stored in tables with rows and columns These databases are well suited for data that can be easily organized into a tabular format and are useful for data warehousing business intelligence and other reporting applications NoSQL databases such as MongoDB and Cassandra are designed to handle large amounts of unstructured data and support different data models such as document key value and graph These databases are useful for big data and real time applications such as real time analytics social media and gaming Graph databases such as Neoj and Amazon Neptune are used to store and query data in a graph format where nodes and edges represent entities and relationships These databases are useful for applications that involve complex relationships such as fraud detection recommendation systems and social network analysis In data science the choice of DBMS depends on the type and volume of data the complexity of the relationships among data and the performance and scalability requirements of the application In this article we will study in detail Relational databases Basic UnderstandingA relational database is a type of database that organizes data into tables with each table consisting of rows and columns Tables A table is a collection of related data that is organized into rows and columns Each table has a unique name that identifies it within the database For example a table named customers might contain information about all the customers of a company with each row representing a different customer and each column representing a different piece of information about that customer such as name address and phone number Columns A column is a vertical set of values in a table and it has a name and a data type Each column represents a specific attribute of the data in the table such as customer name or customer address For example in a table named customers the columns could be customer id customer name customer address customer phone number customer email etc Rows A row is a horizontal set of values in a table and it represents a single record or tuple in the table Each row represents a unique instance of the data in the table such as a specific customer For example in a table named customers a row could represent a single customer with values such as for the customer id John Doe for the customer name Main St for the customer address for the customer phone number and johndoe gmail com for the customer email Primary keys A primary key is a column or set of columns in a table that uniquely identify each row in the table Each table can have only one primary key and it is used to enforce the integrity of the data and create relationships with other tables For example in a table named customers the customer id column might be the primary key because it is unique for each customer and can be used to identify a specific customer in the table Foreign keys A foreign key is a column or set of columns in a table that refers to the primary key of another table It is used to create relationships between tables and enforce referential integrity For example in a table named orders that contains information about customer orders the customer id column might be a foreign key that refers to the primary key customer id in the customers table Indexing Indexing is the process of creating a separate data structure that allows for faster searching and sorting of data in a table Indexes can be created on one or more columns in a table to improve the performance of queries that search for specific data For example if you frequently search for customers by their last name you might create an index on the customer name column in the customers table to speed up those searches Here is an example of a customers table customer idcustomer namecustomer addresscustomer phone numbercustomer emailJohn Doe Main St johndoe gmail comJane Smith Park Ave janesmith gmail comBob Johnson Elm St bobjohnson gmail comIn this example table the customer id column is the primary key and it is used to uniquely identify each customer The other columns such as customer name customer address customer phone number and customer email are non key attributes and they provide additional information about each customer An index can be created on any column to speed up the query performance In this example an index can be created on the customer name column if we frequently need to search customer by their name It is important to note that the example is a very simple representation of the table and in real world scenario tables can have multiple columns as primary key multiple foreign keys and a complex data model with multiple tables but the basic concept remains the same SQL QuriesWe will execute all our queries using Python and SQLite Connecting to a databaseTo start interacting with the database we first we need to establish a connection usr bin pythonimport sqliteconn sqlite connect daysofdatascience db print Opened database successfully Opened database successfully Sample data Customers table conn execute CREATE TABLE customers id INT PRIMARY KEY first name VARCHAR last name VARCHAR city VARCHAR conn execute INSERT INTO customers id first name last name city VALUES John Smith Paris Mary Johnson London Michael Williams Berlin Brad Brown Rome print Customer table created successfully Customer table created successfully Products table conn execute CREATE TABLE products id INT PRIMARY KEY product name VARCHAR category VARCHAR price DECIMAL in stock BOOLEAN conn execute INSERT INTO products id product name category price in stock VALUES MacBook Pro electronics true iPhone electronics true T Shirt clothing true Jeans clothing false print Products table created successfully Products table created successfully Orders table conn execute CREATE TABLE orders id INT PRIMARY KEY customer id INT order date DATE total DECIMAL conn execute INSERT INTO orders id customer id order date total VALUES print Orders table created successfully Orders table created successfully Create the employee tableconn execute CREATE TABLE employees id INT PRIMARY KEY NOT NULL name TEXT NOT NULL salary REAL Insert data into the employee tableconn execute INSERT INTO employees id name salary VALUES John Smith conn execute INSERT INTO employees id name salary VALUES Mary Johnson conn execute INSERT INTO employees id name salary VALUES Michael Williams conn execute INSERT INTO employees id name salary VALUES Brad Brown print Employees table created successfully Employees table created successfully conn commit Here are some examples of basic to advanced SQL queries that a data scientist might use to retrieve and manipulate data SELECT The SELECT statement is used to retrieve data from one or more tables For example the following query retrieves all columns from a table called customers import pandas as pddata pd read sql query SELECT FROM customers conn dataidfirst namelast namecityJohnSmithParisMaryJohnsonLondonMichaelWilliamsBerlinBradBrownRome WHERE The WHERE clause is used to filter the data returned by a SELECT statement For example the following query retrieves all columns from the customers table for customers whose city is New York data pd read sql query SELECT FROM customers WHERE city London conn dataidfirst namelast namecityMaryJohnsonLondon JOIN The JOIN clause is used to combine rows from two or more tables based on a related column between them For example the following query retrieves all columns from the orders table and the customers table where the customer id in the orders table matches the id in the customers table data pd read sql query SELECT FROM orders JOIN customers ON orders customer id customers id conn dataidcustomer idorder datetotalidfirst namelast namecity JohnSmithParis MaryJohnsonLondon MichaelWilliamsBerlin MaryJohnsonLondon UPDATE The UPDATE statement is used to modify data in a table For example the following query updates the salary of all employees in the employees table by conn execute UPDATE employees SET salary salary conn commit data pd read sql query SELECT FROM employees conn dataidnamesalaryJohn SmithMary JohnsonMichael WilliamsBrad Brown DELETE The DELETE statement is used to remove data from a table For example the following query deletes all rows from the employees table where the salary is less than conn execute DELETE FROM employees WHERE salary lt conn commit data pd read sql query SELECT FROM employees conn dataidnamesalaryMary JohnsonMichael WilliamsBrad Brown GROUP BY The GROUP BY clause is used to group rows in a SELECT statement based on one or more columns For example the following query retrieves the total in stock for each product category data pd read sql query SELECT category SUM in stock FROM products GROUP BY category conn datacategorySUM in stock clothingelectronics ORDER BY The ORDER BY clause is used to sort the data returned by a SELECT statement For example the following query retrieves all columns from the customers table sorted by last name in ascending order data pd read sql query SELECT FROM customers ORDER BY last name conn dataidfirst namelast namecityBradBrownRomeMaryJohnsonLondonJohnSmithParisMichaelWilliamsBerlin LIMIT The LIMIT clause is used to limit the number of rows returned by a SELECT statement For example the following query retrieves the top products by in stocks data pd read sql query SELECT FROM products ORDER BY in stock DESC LIMIT conn dataidproduct namecategorypricein stockMacBook ProelectronicsiPhoneelectronics LIKE The LIKE operator is used to search for a specific pattern in a column For example the following query retrieves all customers whose last name starts with S data pd read sql query SELECT FROM customers WHERE last name LIKE S conn dataidfirst namelast namecityJohnSmithParis INNER JOIN The INNER JOIN keyword is used to combine rows from two or more tables based on a related column between them This will only return rows when there is at least one match in both tables For example data pd read sql query SELECT orders id customers first name FROM orders INNER JOIN customers ON orders customer id customers id conn dataidfirst nameJohnMaryMichaelMary OUTER JOIN The OUTER JOIN keyword is used to combine rows from two or more tables based on a related column between them This will return all rows from one table and the matching rows from the other table If there is no match NULL values will be returned For example data pd read sql query SELECT orders id customers first name FROM orders LEFT OUTER JOIN customers ON orders customer id customers id conn dataidfirst nameJohnMaryMichaelMary UNION The UNION operator is used to combine the result set of two or more SELECT statements The UNION operator selects only distinct values by default For example data pd read sql query SELECT FROM orders UNION SELECT FROM customers conn dataidcustomer idorder datetotal JohnSmithParis MaryJohnsonLondon MichaelWilliamsBerlin BradBrownRome INDEX Indexes are used to improve the performance of a database by allowing the database to find and retrieve specific rows much faster For example the following command creates an index on the last name column in the customers table conn execute CREATE INDEX last name indexes ON customers last name conn commit Date and Time Functions SQL provides a number of functions to work with date and time data types Some examples include CURDATE returns the current dateNOW returns the current date and timeYEAR returns the year of a given dateMONTH returns the month of a given dateDAY returns the day of a given dateAs we are using SQLite So SQLite provides several built in functions for working with date and time Here is a list of some of the most commonly used date and time functions in SQLite date timestring modifier modifier This function returns the date part of a date time string time timestring modifier modifier This function returns the time part of a date time string datetime timestring modifier modifier This function returns the date and time parts of a date time string julianday timestring modifier modifier This function returns the Julian day the number of days since noon in Greenwich on November B C strftime format timestring modifier This function returns a string representation of the date and time based on the specified format The format string can contain various placeholders for different parts of the date and time such as Y for the year m for the month d for the day H for the hour M for the minute and S for the second date timestring or number days or months or years This function allows you to add or subtract days months or years from a date current date current time current timestamp These functions return the current date time and timestamp respectively year timestring month timestring day timestring hour timestring minute timestring second timestring These functions return the year month day hour minute and second of the given timestring respectively For example the following query retrieves the total sales for each month of the current year data pd read sql query SELECT strftime m order date as month SUM total as totals FROM orders WHERE strftime Y order date strftime Y now GROUP BY month conn Handling NULL values SQL provides several operators and functions to handle NULL values Some examples include IS NULL used to check for NULL valuesIS NOT NULL used to check for non NULL valuesCOALESCE returns the first non NULL value in a list of expressionsNULLIF returns NULL if two expressions are equal otherwise it returns the first expressionFor example the following query retrieves all customers who have not placed any orders data pd read sql query SELECT FROM customers WHERE id NOT IN SELECT customer id FROM orders conn dataidfirst namelast namecityBradBrownRome Other data types SQL also supports other data types such as BLOB binary large object for storing binary data BOOLEAN for storing true false values and ENUM for storing predefined set of strings For example the following query retrieves all products with image and only if the products are in stock data pd read sql query SELECT product name in stock FROM products WHERE product name IS NOT NULL AND in stock TRUE conn dataproduct namein stockMacBook ProiPhoneT Shirt SummaryThis article provides a comprehensive guide to relational database management systems RDBMS and SQL Structured Query Language for data science and analysis It covers the basics and advanced concepts of RDBMS and SQL including data types queries and advanced concepts such as joins and subqueries The article also provides examples and code snippets to help illustrate the concepts and provide a hands on learning experience The main goal of this article is to help data scientists analysts and developers understand the importance of RDBMS and SQL in managing and analyzing large datasets Exercise Question you will find in the exercise notebook of Day on GitHub If you liked it then	2023-01-12 11:20:40
Apple	AppleInsider - Frontpage News	Cybercriminals shall not pass: how to protect your Macs and yourself from the most popular cyber threats	https://appleinsider.com/articles/23/01/12/cybercriminals-shall-not-pass-how-to-protect-your-macs-and-yourself-from-the-most-popular-cyber-threats?utm_medium=rss	Cybercriminals shall not pass how to protect your Macs and yourself from the most popular cyber threatsThe Internet is a dangerous place with many potential attacks that could be costly to your digital life Here s how to keep your Mac and your online identity secure from threats Keep your data safe with simple security practicesIn the number of attacks in cyberspace has increased significantly According to Check Point Research global attacks increased by in the third quarter of compared to the same period in Read more	2023-01-12 11:59:20
Apple	AppleInsider - Frontpage News	Apple's Music & TV apps hit Windows - but only Windows 11	https://appleinsider.com/articles/23/01/12/apples-music-tv-apps-hit-windows---but-only-windows-11?utm_medium=rss	Apple x s Music amp TV apps hit Windows but only Windows Apple has quietly released PC apps for Apple Music and TV ーbut the new apps will not run on the near ubiquitous Windows Apple replaced iTunes for Mac users in splitting its functions out into separate apps for Apple Music Apple TV and into macOS Catalina As big a shakeup as it seemed iTunes had slowly gone from simple to perplexing Now four years later Apple is doing the same thing for Windows ーalthough specifically only for Windows users At present iTunes for Windows is still the only app officially available in Microsoft s store but preview releases of Apple Music and Apple TV can be found Read more	2023-01-12 11:52:17
Apple	AppleInsider - Frontpage News	How to make a TikTok sound an iPhone ringtone	https://appleinsider.com/inside/iphone/tips/how-to-make-a-tiktok-sound-an-iphone-ringtone?utm_medium=rss	How to make a TikTok sound an iPhone ringtoneIt s possible to create text tones or ringtones for your iPhone from your favorite TikToks ーand for free Here s how to do it TikTok is a hub for burgeoning creators and artists Whether you want that viral cat meow as your text tone that new artist s song as your ringtone or want to assign that hilarious goat s scream as your brother s personalized text tone this article teaches you how to customize your tones by downloading different sounds from your favorite TikTok creators Getting started Read more	2023-01-12 11:37:18
Apple	AppleInsider - Frontpage News	New AirPods Max & $99 AirPods rumored for late 2024	https://appleinsider.com/articles/23/01/12/kuo-new-99-airpods-new-airpods-max-will-ship-in-the-second-half-of-2024?utm_medium=rss	New AirPods Max amp AirPods rumored for late According to Analyst Ming Chi Kuo Apple will be adding a budget model to its AirPods lineup by late at the earliest AirPods Analysts have recently suggested that Apple may develop a lite version of its AirPods to compete against cheaper wireless earbuds Read more	2023-01-12 11:34:24
海外TECH	Engadget	Meta Quest now syncs workouts with Android phones and pairs with heart-rate trackers	https://www.engadget.com/meta-quest-health-connect-android-heart-rate-tracker-pairing-113045125.html?src=rss	Meta Quest now syncs workouts with Android phones and pairs with heart rate trackersIn a report about VR fitness The Washington Post cited a Forrester research that said percent of American adults online are interested in buying a VR headset and percent think they d primarily use it for exercise VR fitness is a growing space and Meta has rolled out a couple of new health related features for its Quest headset that could convince even more people to give it a try In its latest update for the device the company has rolled out Health Connect integration for Android users and as The Verge nbsp reports the ability to pair Bluetooth heart rate monitors with it nbsp A Meta spokesperson told the publication that if paired with a compatible heart rate monitor the Meta Quest Move overlay can display a user s heart rate on any game or app alongside minutes exercised and calories burned At the moment the only known compatible monitors are the Garmin HRM Dual and the Polar H chest straps but other brands and models even smartwatches may be able to pair with the headset Meta just can t confirm if they ll work with the Quest as it intended nbsp Meanwhile Health Connect integration will give users the capability to automatically sync VR workouts with their Android device Meta first made people s VR fitness stats viewable outside of their headsets when it gave iOS users the capability to sync their progress with Apple Health last year Now Android users can finally see their progress without having to put on the Quest as well nbsp The Health Connect API enables health and fitness data sharing across devices and between apps such as Samsung Health and MyFitnessPal To activate the integration users will first have to sync their Meta Quest Move stats with the Meta Quest mobile app They can do so by going into the Move app in VR and clicking Settings Users will then have to toggle on Health Connect by Android under the Connected Apps section inside the Meta Quest mobile app It s unclear if these features are also making their way to the first Quest model released under the Oculus branding A few days ago the company sent out emails to Quest owners telling them that their devices will no longer be getting new features going forward Meta will also only be releasing critical security and bug patches for the device until nbsp	2023-01-12 11:30:45
医療系	医療介護 CBnews	医療広告違反サイト「改善に半年以上」が1割-「行政の怠慢」との指摘も、厚労省検討会	https://www.cbnews.jp/news/entry/20230112202612	医療機関	2023-01-12 20:55:00
医療系	医療介護 CBnews	医療機能情報提供、24年度に刷新へ-厚労省が6項目の追加案	https://www.cbnews.jp/news/entry/20230112200708	医療機関	2023-01-12 20:30:00
金融	RSS FILE - 日本証券業協会	動画で見る日証協の活動	https://www.jsda.or.jp/about/gaiyou/movie/index.html	日証協	2023-01-12 13:00:00
ニュース	BBC News - Home	Jeff Beck: British guitar legend dies aged 78	https://www.bbc.co.uk/news/entertainment-arts-64228780?at_medium=RSS&at_campaign=KARANGA	british	2023-01-12 11:41:29
ニュース	BBC News - Home	Someone runs out of energy credit every 10 seconds	https://www.bbc.co.uk/news/business-64235997?at_medium=RSS&at_campaign=KARANGA	meters	2023-01-12 11:54:34
ニュース	BBC News - Home	Weather: Floods in Wales cause power cuts and train delays	https://www.bbc.co.uk/news/uk-wales-64246302?at_medium=RSS&at_campaign=KARANGA	heavy	2023-01-12 11:55:50
ニュース	BBC News - Home	Second batch of classified Biden documents found	https://www.bbc.co.uk/news/world-us-canada-64244007?at_medium=RSS&at_campaign=KARANGA	house	2023-01-12 11:12:46
ニュース	BBC News - Home	Rishi Sunak and Nicola Sturgeon to hold talks in Scotland	https://www.bbc.co.uk/news/uk-scotland-scotland-politics-64247552?at_medium=RSS&at_campaign=KARANGA	minister	2023-01-12 11:15:57
ニュース	BBC News - Home	NHS Tracker: How are your local NHS services coping this winter?	https://www.bbc.co.uk/news/health-59549800?at_medium=RSS&at_campaign=KARANGA	severe	2023-01-12 11:55:21
ニュース	BBC News - Home	Manchester United agree Wout Weghorst loan deal	https://www.bbc.co.uk/sport/football/64248740?at_medium=RSS&at_campaign=KARANGA	weghorst	2023-01-12 11:45:55
ニュース	Newsweek	ホームレス女性にホースで水を浴びせる男　国内外から「非道」と批判集中も	https://www.newsweekjapan.jp/stories/world/2023/01/post-100563.php		2023-01-12 20:25:00