Posts

Showing posts from February 15, 2019

List of districts of Odisha

Image
The state of Odisha is in eastern India. Map of districts of Odisha Odisha , a state on the eastern coast of India, is divided into 30 administrative geographical units called districts . [1] [2] [3] These 30 districts have been placed under three different revenue divisions to streamline their governance. The divisions are Central, North and South with their headquarters at Cuttack ( Central Division ), Sambalpur ( Northern Division ), Berhampur ( Southern Division ) respectively. Each division consists of 10 districts, and has as its administrative head a Revenue Divisional Commissioner (RDC), a senior rank officer of Indian Administrative Service. The position of the RDC in the administrative hierarchy is that between that of the district administration and the state secretariat. Each District is governed by a Collector & District Magistrate , who is appointed from the Indian Administrative Service. The Collector & District Magistrate is responsibl

Formatting header in XL Connect

Image
0 I'm using XL Connect across the board to save data to Excel and, for one project, I need to upload a R-generated excel file to Access. I have to change the header row color from gray to no fill in order for Access to accept the file and I would like to do this in my script rather than doing so manually. r xlconnect share | improve this question asked Nov 20 '18 at 0:26 Wozezeka Wozezeka 1 1 add a comment  | 

Fast Way to Replace Names with Ids in Datatable?

Image
1 I have a very large CSV file I have to load on a regular basis that contains time series data. Examples of the headers are below: | SiteName | Company | Date | ResponseTime | Clicks | This data comes from a service external to the uploader. SiteName and Company are both string fields. In the database these are normalized. There is a Site table and a Company table: CREATE TABLE [dbo].[Site] ( [Id] INT NOT NULL IDENTITY(1, 1) PRIMARY KEY, [Name] NVARCHAR(MAX) NOT NULL ) CREATE TABLE [dbo].[Company] ( [Id] INT NOT NULL IDENTITY(1, 1) PRIMARY KEY, [Name] NVARCHAR(MAX) NOT NULL ) As well as the data table. CREATE TABLE [dbo].[SiteStatistics] ( [Id] INT NOT NULL IDENTITY(1, 1) PRIMARY KEY, [CompanyId] INT NOT NULL, [SiteId] INT NOT NULL, [DataTime] DATETIME NO