Shulou(Shulou.com)05/31 Report--

This article mainly explains "case analysis of database data warehouse receipt". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn the "database data warehouse receipt case analysis" bar!

Update interface "futures_czce_warehouse_receipt" # Zhengzhou Commodity Exchange warehouse receipt daily data warehouse receipt daily-Zhengzhou Commodity Exchange

API: futures_czce_warehouse_receipt

Destination address: http://www.czce.com.cn/cn/jysj/cdrb/H770310index_1.htm

Description: provide Zhengzhou Commodity Exchange-Trading data-warehouse receipt Daily

Limited edition: return all daily data of warehouse receipts on the current trading day at a time

Input parameters

Name type required description trade_datestrYtrade_date= "20200702"; transaction date

Output parameter

The name type displays the description key-value pair dictionary dictY key-value pair by default, the key is the variety code, and the value is the data in pandas.DataFrame format

Interface exampl

Import akshare as ak

Czce_warehouse_receipt_df = ak.futures_czce_warehouse_receipt (trade_date= "20200702")

Print (czce_warehouse_receipt_df)

Data example

{'SR': Warehouse number Warehouse abbreviation Annual Grade Brand Warehouse receipt quantity increase or decrease effective forecast discount on the same day

0 0103 Gaocheng Yongan NaN 00 NaN 100

1 0112 Tianjin Army Grain City NaN 0 0 NaN 80

2 0201 Nanjing Iron Core Bridge NaN 00 NaN

3 0404 Rong Gui Qinzhou NaN 0 0 NaN 0

4 0407 Liuzhou Guitang NaN 0 0 NaN 0

5 0409 Yunnan 1920 1 Kangbai 1800 NaN-1700

6 NaN NaN 1920 1 Li Shanxue 800 NaN NaN

7 NaN NaN 1920 1 Sanjing Mountain 200 NaN NaN

8 NaN NaN 1920 1 Xianren Mountain 500 NaN NaN

9 subtotal NaN 33000 NaN

10 0411 Foshan Chinese businessmen NaN 0 0 NaN 80

11 0415 Yingkou Port NaN 0 0 NaN 50

12 0417 China Sugar Hubei 1920 1 Luyuan 407 0 NaN

13 NaN NaN 1920 1 Xiqin 363 0 NaN NaN

14 subtotal NaN 7700 0230 NaN

15 0428 Zhengzhou Nanyangzhai 1920 1 China Sugar 1431 0 NaN

16 subtotal NaN 1431 0 79 NaN

17 0433 Honorable Gui Gui NaN 0 0 NaN 0

18 0434 Guangxi Guigang NaN 0 0 NaN 0

19 0435 Guangxi Hongxin NaN 0 0 NaN 0

20 0436 North Yingkou NaN 0 0 NaN 50

21 0437 Rizhao Ling Yunhai (factory library) 1920 1 ALL 440-50 NaN 50

22 subtotal NaN 440-500 NaN

23 0438 Guangdong Beibu Gulf 1920 1 Ganling 1640 0 NaN 0

24 subtotal NaN 1640 0 NaN

25 0440 Caofeidian NaN 0 0 NaN 50

26 0441 Hongxin Fusui NaN 0 0 NaN 0

27 0444 Chinese sugar Nantong NaN 0 NaN 0444

28 0445 Tunhe (factory warehouse) 1920 1 ALL 5000 0 NaN 50

29 subtotal NaN 5000 00 NaN

30 0447 Starlight Sugar (factory warehouse) NaN 00 NaN 100

31 0449 Shaanxi Xianyang 1920 1 Jingling 500 NaN 80

32 NaN NaN 1920 1 Sugar 1490 0 NaN NaN

33 subtotal NaN 1540 0 NaN

34 0450 Jisheng Logistics NaN 0 0 NaN 50

35 0451 China Sugar Beijing NaN 0 0 NaN 50

36 0452 Yunnan Land Aviation 1920 1 Dawanjiang 40 40 NaN-100

37 subtotal NaN 40 400 NaN

38 0454 Yunou Logistics NaN 0 0 NaN 0

39 0508 Pinghu Huarui NaN 0 0 NaN 180

40 Total NaN 11191-10309 NaN, 'CF': Warehouse numbered Warehouse abbreviated as Annual Grade Origin Warehouse receipts effective Forecast for the increase or decrease in the number of producing areas on the same day

0 0301 Henan State Reserve 1920 1128 Xinjiang 1 0 NaN

1 NaN NaN 1920 1129 Xinjiang 1 0 NaN

2 NaN NaN 1920 1228 Xinjiang 7 0 NaN

3 NaN NaN 1920 1229 Xinjiang 5 0 NaN

4 NaN NaN 1920 2127 Xinjiang 20 NaN

.. ...

368 NaN NaN 1920 3129 Xinjiang 41 0 NaN

369 NaN NaN 1920 3130 Xinjiang 8 0 NaN

370 NaN NaN 1920 4129 Xinjiang 5 NaN

371 subtotal NaN 86 0 1

Total NaN 20641-261 2203}

At this point, I believe that you have a deeper understanding of the "database data warehouse receipt instance analysis", might as well come to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.