Footfall | Application that allows you to monitor the traffic

I am a novice at R programming and stuck with a problem.

Here's a sample dataset:

So I have a device which provides me the footfall count (in and out). It generates a csv based on number of lines drawn. The csv format is like:

timestamp, in, out

The above case is for if i have only 1 line. However, I am getting several in/out per row, with this format:

timestamp, in, out, in, out, in, out, in, out

Example of input:

I have a restaurant sales details as below.

I'm trying to request data from a JSON API from Vemcount - a footfall-sensor system. I want to retrieve all my company's data and store it in a SQL Server db using SSIS. During my research I've realized that JSON is not natively integrated with SSIS, so solutions are either hardcoding the import or using a 3rd party - I've chose to go with the latter, so currently I'm trying to do the request using Kingswaysoft and their JSON Source component in VS.

The URL looks something like this (example from their documentation, which can be found here):

I have a c# application that works locally but it wont work if I publish my program on another machine. I get an error saying the server name cannot be found.

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in ProductionOrderQuery.exe

Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Both machines are on the same corporate domain network. it may be something to do with how I am specifying my server name? Do I have to simply write the server name or do i need the fully qualified domain name?

The connection string is

Im attempting to populate a listbox from a database on form load, but when i load the form no data appears. The connection to the database is setup in VS 2017 and thats where I got the connection string.

I have two dataframes one is topic_ which is the target dataframe and tw which is the source dataframe. The topic_ is a topic by word matrix, where each cell stores the probability of a word occurring in a particular topic. I have initialized the topic_ dataframe to zero using numpy.zeros. A sample of the tw dataframe-

I am using topic_.set_value(each_topic, word, prob) to change the value of cells in a pandas dataframe. Basically, I initialized a numpy array with a certain shape and converted it to a pandas dataframe. I am then replacing these zeros by iterating over all the columns and rows using the code above. The problem is that the number of cells are around 50,000 and every time I set the value pandas prints the array to the console. I want to suppress this behavior. Any ideas?

EDIT

I have two dataframes one is topic_ which is the target dataframe and tw which is the source dataframe. The topic_ is a topic by word matrix, where each cell stores the probability of a word occurring in a particular topic. I have initialized the topic_ dataframe to zero using numpy.zeros. A sample of the tw dataframe-