HISTORICAL WEATHER DATA ARRIVES IN EXCEL

摘要

The WolframAlpha data is found on the Data tab, beneath the existing Stocks and Geography data types. Although the gallery offers Chemistry, Element, Space, Satellite, Movie, Food, Activity, University, Location, and ZIP Code data types, there are dozens more available under the Automatic category. To accommodate the rich data, Excel improved the data types. A single formula can now return an array of values. If you ask for historical monthly weather, you'll automatically receive 12 rows of answer. Ask for weekly or daily data, and Excel will populate 53 or 366 cells. While the old Geography data type might have offered 12 fields for each city, the new Location data type offers hundreds of data fields including population statistics by age, gender, race, education level, and household income. To get started, you need a Home or Stu- dent edition of Microsoft 365. On the File, Account tab, opt into the Office Insiders program, choose the Beta level, and then restart Excel twice. Type one or more cities in a column. Select the cities and choose Data, Data Types, Location. Wolfram-Alpha will convert the cells to a rich data type and add an icon with two buildings. If your original data said "Columbus, Indiana," then the conversion will happen quickly. But if your cell says "Columbus," you'll have to use a Data Selector panel to specify which Columbus you mean.